ITrack/Crystal Reports Failed to retrieve from the database

From ISoft Wiki
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.