Crystal reports failed to retrieve data from the databse

Asked By 0 points N/A Posted on -
qa-featured

Can anyone help me here? I just got an error when I started my computer today. I have no ideas where it came from so troubleshooting is hard. All ideas are welcome.

Failed to retrieve data from the databse

Details:ADO error code 0x80004005

Source: Microsoft OLE DB Provider for visual FoxPro

Description:SQL: Colum DATETIME is not found

Native Error: 806 [Database vendor code 806]

SHARE
Answered By 0 points N/A #176738

Crystal reports failed to retrieve data from the databse

qa-featured

The Visual FoxPro v.9 Database files can only be accessed via OLE DB (ADO). However, there is a problem with OLE DB trying to filter VFP9 records in a date time formatted field.  This error shown is self explanatory telling you that there is some problem with DATETIME format in your SQL server using OLE DB connection for visual FoxPro. Changing date format will not solve the problem. You have to filter it to DATE (only) format and it would definitely work for you.

So you have to change DATETIME format to DATE only. Define a report variable called new_cust.entrydate and filter it:

{cust.entrydate} >= DateTime (2010, 01, 01, 00, 00, 00) would instead be written:

{new_cust.entrydate) >= Date (2010, 01, 01)

 

 

Related Questions