Skip to Content
0
Former Member
Feb 20, 2009 at 04:44 AM

report command fails in Crystal, but succeeds in SQL Mgt Studio

343 Views

The Error reads:

Failed to retrieve data from the database.

Details: ADO Error Code: 0x80040e07

Source: Microsoft OLE DB Provider for SQL Server

Description: The conversion of char data type to smalldatetime data

type resulted in an out-of-range smalldatetime value.

SQL State: 22007

The report was receiving this same error last week and so I went through the data in the database until I found the invalid date value and had the customer correct it. When the SQL ran in SQL Server Mgt Studio, I expected it to run in Crystal too, but it failed again. Is there any reason that Crystal would give this error when I can run the command in SQL?

thanks

michele