ITrack/Crystal Reports Failed to retrieve from the database
From ISoft Wiki
< ITrack(Redirected from Crystal/Failed to retrieve from the database)
Jump to navigationJump to search
Cause
Crystal Reports failed to get information to fill out the report, even though it did connect before the failure.
Solution
- In most cases, this error is caused by the specific report.
- Most likely, the internal query of the report failed when it was run. The report (or database structure) may be out of date.
- Check ODBC, if its pointed to an actual server with a valid username and password but the database/table/field doesn't exist on this server(most likely because its not the correct server), you'll get this error.
Database Vendor Code: 506
This is caused by the MySQL ODBC driver incorrectly parsing comments. The bug is fixed as of version 5.2.4.
