cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal 2008 on Win 7 64-bit - logon failure to Oracle DB

Former Member
0 Kudos

I'm running Crystal Reports 2008 (version 10.5.0.0) on Windows 7 64-bit.  Using the 32-Bit Data Source (ODBC) link under the Crystal Reports 2008 program directory, I've set up a User DSN (and System DSN) to the oracle database with the driver provided by the Oracle client (Oracle in OraClient10g).  I can successfully test connect from there.  However, when I run reports (created in CR 11.0.0.895) I run into the following error.

I see lots of discussion about 32-bit/36-bit ODBC as problematic.  I was wondering if it might be an issue with the version of Oracle client I'm using (32-bit 10.2.01) and a newer client might resolve the problem. 

Accepted Solutions (0)

Answers (2)

Answers (2)

JWiseman
Active Contributor
0 Kudos

hi Jacqueline, another option would be to go clientless using the data direct wire protocol drivers, which also claim to have better performance.

in cr2008 though i believe that the driver number may be 5.3 and not 6.

-jamie

DellSC
Active Contributor
0 Kudos

Actually, the error above points to an OleDB driver, not ODBC - the two are different.  However, is there a specific reason why you're using an ODBC connection and not the Native Oracle connection that's available through Crystal?  I have found the native Oracle connection to be MUCH more stable and reliable than ODBC in the (many) years that I have been using Crystal.

-Dell