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