Oracle 11g Table/View not Displayed

building reports crystal reports
1

This is a strange issue. I create a table and a few views in Oracle 11g but when I try to point Crystal to them, they are not displayed.

When I first connected via an Oracle Server connection from Crystal, they were there. I noticed the error when I tried to run the report and it said the table and view does not exist. Here’s my info

Crystal Reports XI R2 SP3
Oracle 10g Client (9i client on laptop, same issue)
Connection to Oracle 11g server

I can see all the other views and tables, just not the newly created ones. Has anyone ever experienced this issue?

Thanks,
Anvy

Anverion (BOB member since 2007-03-15)

2

Have you tried an ODBC connection (Im assuming youve tried a native connection)

ABILtd :uk: (BOB member since 2006-02-08)