Crystal Reports failing in production after Oracle 10g Upgrade

[Maven4Champ]

All,

Our Crystal reports are failing after upgrade to Oracle 10g db version.

Here is the breakdown:

Crystal 8.5
Using pdsora7.dll native Oracle driver for connectivity
Database is Oracle 10g
Connecting through Crystal Report Viewer in VB app or Crystal Reports client yields the following error(s):

Server not yet opened AND ORA-01034: ORACLE NOT AVAILABLE.

TNS entry is correct and trying ODBC doesn't work either. Any advice?

 

[MJRBIM]

I know that the Oracle 9i client was the MINIMUM required for Crystal Reports XI.

Maybe the old unsupported Crystal Reports 8.5 that you are using doesn't work with the more recent Oracle 10g database.

Can't say 100% as I don't have any machines still running CR-8.5.

 

[Turkbear]

Hi,
Are you sure the Oracle instance is up and running and that you can connect to it using the ODBC driver?

Tha message usually means that the instance is down..

Is pdsora7.dll the latest CR driver you have?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Maven4Champ]

The Oracle instance is indeed up and running. I have validated through SQL Plus session. And pdsora7.dll is the latest driver I have through CR 8.5.

 

[MJRBIM]

I am pretty sure that pdsora7.dll will not be forwards-compatible to Oracle 10g.

Can you configure a more current Oracle driver as a SYSTEM connection under ODBC - and repoint your RPT files at that OBDC..?

 

[Maven4Champ]

Which ODBC should I use (ODBC for Oracle Client 10g - OR - Microsoft ODBC for Oracle Database)?

I can attempt that and see if it changes - just need the direction to go.

 

[MJRBIM]

I would use "ODBC for Oracle Client 10g

 

[Turkbear]

Hi,
Instead, at least in the CR client, use the 'native' Oracle driver ( usually under Oracle in the database list when choosing a datasource - sometimes under 'other') - assuming the Oracle client software was installed before CR.

In VB use a DSN-less ADO connection instead of ODBC.



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Maven4Champ]

OK - making some progress. I changed the TNS entries for the database I am connecting to and its now working. Crystal 8.5 and pdsora7.dll work fine with Oracle 10g. Our secondary problem is that our VB application that uses Crystal Report Viewer, etc. is running extremely slow. Is there something that would jump out as needing investigation as we dive into this issue to see the root-cause of slowness?

Thanks,
Michael

 

[MJRBIM]

Is you VB-app a compiled thick-client on the desktop, a limited web-app with the Crystal Runtime, or a full SDK application connecting to Crystal Enterprise 8.5...?