Skip to Content
0
Former Member
Jan 03, 2009 at 06:35 PM

Problem creating new data sources

29 Views

hi -- I've just created a file DSN data source (Microsoft ODBC for Oracle Driver), and in Crystal, have used the ODBC (RDO) data source type, pointing to the file DSN. (I'm accessing an Oracle 10g database on a Unix server.)

The connection to the database is successful, but when I use the Database Expert to pick the actual object (eg table) that I want the report to access, I get the following strange results:

Not all schemas are visible

For the schemas that are visible, only stored procedures are shown. No tables, views, or anything else.

When I create an Oracle Server data source, all schemas and their objects are visible. The report works fine.

Can someone explain to me why the File DSN is not showing me all schemas and objects?

Thanks,

Carol