Skip to Content
0
Former Member
Nov 20, 2008 at 06:33 PM

Not seeing all DB tables in Crystal using ODBC connection

164 Views

I have an ODBC connection to an oracle database. I can connect to the database and see all the tables through tools such as TOAD, SQL developer, SQLPlus, etc. However, in Crystal, i only see schema tables and not the tables I want. I am using the same connection, username, and password. If I run a report that was created in a different environment to the correct tables, I receive the error: ORA00942: table or view does not exist.

Oracle 10g

Crystal 12.0.0.683

Any suggestions?

Thanks,

Diana Woronuk