Connection to Crystal Reports

[fox12]

I used ODBC connection in Crystal Reports 9 (Windows 2K). However, under the schema "Test_A", I only found a few functions I just created. I am not able to find any tables and views to access any data. Of course, I used the correct user name and password for connection. What may be wrong. I can find all of those tables/views if I logged in from PL/SQL prompt and Oracle Enterprise Manager.

What maybe wrong? Thanks for your advice.

Fox12

 

[Turkbear]

Hi,
I assume you mean the SqlPlus prompt ( Pl/Sql has no prompt)..

Try switching to a Native Oracle connection instead of ODBC...It is under Database..More Data Sources ( called Oracle Server)

Much more reliable then ODBC and far less dependent on Driver version/Manufacturer ( should you use Oracle's ODBC, MS's, Crystal's ???)..

 

[Turkbear]

Hi again,
Also check the 'options' button on your connection to be sure you are not screening out certain objects.

 

[fox12]

Turkbear,

Within Crystal Reports, if I used the Oracle Server by clicking "Create New Connection", I had no problem in finding all tables/views. Because I have to build the report into another application, I got to use ODBC connection. It is under ODBC connection that I find no tables/views. I don't filter out tables/views under the "Options" of my connection.

Any idea about this?

Thanks.

Fox12