Re: Upgrade to 10g, now Crystal Reports 8.5 not seeing all tables

google_groups_at_threenorth.com wrote:
> We have an ERP database that we just upgraded to 10g from 8i. We have
> made extensive use of Crystal Reports.
>
> We use PL/SQL Developer for query testing when creating reports. The
> ERP product allows us to integrate the Crystal Reports within their
> interface. Unfortunately, they only support CR 8.5.
>
> Since the upgrade we have run into a few problems where CR 8.5 is not
> seeing all tables. We have tried installing the 10g client and the 8i
> client. With either Oracle client, we can see all tables in PL/SQL
> Developer. With either client, we cannot see all tables in CR.
>
> I've done some poking around the web, but I have not found anything on
> this. It could be that I missed it because Google and Google Groups
> searches on Oracle 10g, Crystal Reports 8.5 and table problem (or other
> variations) either return a few hits that don't help or return a ton of
> non-specific hits.
>
> Thanks!

Get out of PL/SQL Developer into SQL*Plus and see, with the user-id and password you are using who owns the tables and what type of table and the column types? What do you see?

Are you using the native connection (as you should) or ODBC?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)