Oracle Data Access error

[cantademorna]

After making a new data connection using the Oracle Server option, the tables are recognised and appear in the available data sources box but when I click to select an actual table the first error is:

Query Engine Error 'ORA-00942 : Table or view does not exist'

second error appears as:

Query Engine Error : 'Fail to Execute SQL Statement. OCI Call: OCIStmtExecute'

Thanks everybody

 

[Turkbear]

Hi,
Which Database Driver/Version?
Which Oracle version?

 

[cantademorna]

Hey Turkbear

the driver is the standard crdb_oracle.dll one which
comes with the standard V10 developers version.
The Oracle is version 7.3.4.5.0
On Oracle 8 & 9 it seems to recognise and select the tables.
In this instance when you come to the Data box to chose the data source the tables and views are indeed shown, the views
are selectable, but with the tables they are not then the errors comes up. Something to do with Oracle 7?

 

[Turkbear]

Hi, Could well be, it is very old and the newest Oracle drivers ( is your Oracle Client V9.2 ? ) will not communicate with it...

If your Oracle client is V8.0 or 8i then try using the Native Oracle connection from Crystal ( Under More Data Sources..Oracle Server)

 

[cantademorna]

Yeah, tried that initially and still giving the same error.
I suppose CR10 isn't meant to correspond with Ora7 is it?

 

[Turkbear]

Hi,
Crystal will use the Oracle client, regardless of which way you set the connection ( ODBC, OLE DB or Native), so that version is the key..Is your Oracle client v9.2? If so, it will never work with the V7 Oracle database.

 

[cantademorna]

Sorry Turk

Didn't catch your prev post, yes the Oracle client is v8, yeah I know it is supposed to work but it doesn't, I heard you can 'create a new dictionary using the driver' but how?