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 22.214.171.1246.
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
Try installing SP4 from the following link
As an alternative workaround you can also create a report using SQLServer Native client (2000.85.1117)
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem