User`s guide

C.5 Failed to retrieve data from the database. Details: [Database Vendor Code: <vendor
code number>]
Context
Occurs when refreshing or previewing a Crystal report that does not contain saved data.
Reason
The report SQL queries that have been sent to the server cannot be executed, because an error was
returned by the database server after it processed the queries. For example, a field/table/procedure
required by the report is missing, or the queries contain syntax errors.
Resolution
Ensure the report is using the correct connection information. For example, the data source name,
server name, database name, and user name are correct.
In a database client test tool, ensure that the fields, tables, and procedures used by the report exist,
and that SQL queries can be executed against them.
In the Crystal Reports designer, verify that the SQL query, as shown under the Database menu Show
SQL Query option does not contain syntax errors.
If the SQL query shown in Crystal Reports is valid, execute the same SQL query through a database
client test tool.
2012-03-14677
Crystal Reports Error Messages