Connection to Oracle - Can't see tables, only procedures 1

[DavidSherring]

I am connecting to Oracle 10g, through ODBC drivers, from Crystal 9. When I am connected, I try to add tables to my report, only to find there are no tables there, only programming procedures and code.

The previous person to use this machine and write reports here used to write solely in oracle, not using any of the functionality of crystal. She would just produce a cursor and report off that.

Is there a setting within crystal or odbc that would diable the view of tables? Has anyone ever heard of such a thing, as this is really weird, and has everyone in the department stumped.

 

[LizSara]

have you gone into File - Options - Database and checked that tables and views is ticked?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[DavidSherring]

Thanks LizSara, I have been getting some pretty weird things happen in crystal in my time, but this threw me. Funnily enough, when logging on via other odbc links, or straight through oracle drivers, using same logon, this wasn't happening. Anyway, working for now, so thank you very much.

David