1292392 - Err Msg The database table <tablename>; cannot be found. Proceed to remove this table from the report?

SAP Knowledge Base Article - Public

1292392 - Err Msg The database table <tablename>; cannot be found. Proceed to remove this table from the report?

Symptom

When using the MSSQL Server 2005 Native Client Access ODBC driver to connect to MSSQL Server 2005 database, the following dialog prompt appears when reporting off any table in the database:

"The database table <tablename> cannot be found. Proceed to remove this table from the report?"

If you click 'YES', the report does not return data.

If you click 'NO' for all tables, the report will run fine.

The prompt should not appear unless the tables have actually changed. However, the message is occuring even when no changes are present.

This issue only occurs when running Crdb_odbc.dll, version 11.5.8.826.

Reproducing the Issue

1.Install MSSQL Server 2005 in the machine

2.Try creating a sample database with the name that contains special characters like "CP_Customer"

3.Create ODBC connection using SQL Native client Drivers (2005.9.00.3042)

4.Create a new report using ODBC connection

Resolution

Try installing SP4 from the following link

http://resources.businessobjects.com/support/additional_downloads/service_packs/crystal_reports_en.asp#CRXIR2

 As an alternative workaround you can also create a report using SQLServer Native client (2000.85.1117)

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI R2