Crystal reports failed to retrieve data from the databse

Asked By smith shirley 0 points N/A Posted on - 10/15/2013

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]

• Status: Open
• Question Views: 808
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Alexander Jose 0 points N/A #176738

Crystal reports failed to retrieve data from the databse

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)

 

 

About Alexander Jose

Questions
0

Answers
100

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/17/2013
• Question Category: Misc Software