Crystal Reports ODBC connection: the database table <tablename> cannot be found -

when running (or verifying database) report in crystal reports 10, getting message:

"the database table "sometable" cannot found. proceed remove table report?"

for multiple tables.

the report used work fine. report getting data multiple sources, , missing tables coming odbc connection sql server db. think issue may when report created, odbc pointing @ different instance of database (same structures, different location.)

i've checked , report user has required permissions on new database.

in crystal, if ignore messages report seems run fine. when deploying report run within crystal report viewer in website, throwing file i/o error.

this handy blog post provides solution: https://wisdomofsolomon.wordpress.com/2011/06/18/crystal-reports-tables-not-found-during-verify-database/

by running show sql query can see generated query running sql like

select * databasename.dbo.sometable 

it's databasename part of that seems causing problem (although far tell, in case db name isn't different between old db connection , new 1 in case.) amending table queries remove databasename sql solved problem me.

you can follows:

• go database / set datasource location in menus.
• drill down in report tree tables causing problem
• under properties, click overriden qualified table name:
• in text box, type name of table without database name (e.g. dbo.sometable)
• do tables causing problem

(as comment on blog post points out, create new connection , replace tables equivalents new datasource, leaves qualified table name new connection - might same problem again in future.)