We are in the process of upgrading to Oracle 11g from 10g. Now that we have our tns names pointing to the 11g environment, the reports all run fine, but when we open up Crystal and go into the Database Expert to add/delete a table, we cannot see any of the tables with the existing connection to the oracle database. I've tried using both oracle 10g and oracle 11g ODBC drivers and I'm getting the same results.
It's not that the connection is giving any error, but the only "tables" available to select from using the connection are functions and stored procedures. It's not allowing us to view any of the tables.
We checked the permissions and using any other tool to connect, it works fine, which leads me to believe that it has something to do on the Crystal side. If I create a new connection using native oracle with the same TNS string as I was using with the ODBC, it works just fine as well. I'm wondering if the RDO type ODBC is not compatible with 11g.
Has anyone ran into this before? Any suggestions? Thanks!