Irfan's World

April 23, 2011

Crystal Reports 2008: Failed to open the connection. test_oracle Details: [Database Vendor Code: 12154 ] – Resolved

Filed under: SAP Crystal Reports — Irfan @ 12:13 am

After spending lot of time on Google to fix the connectivity issue on Windows 7 64bit between Oracle 10g and Crystal Reports 2008 SP3, I thought I should write this post that may assist some of my readers including me for future reference down the road.  There is not much information available on the web and not any documentation about this issue.  The above error appears sometimes in Business Objects 3.1 SP3 Infoview or when you connect Crystal Reports 2008 Designer Tool to Oracle 10g database.

Remember the following steps:
a) Crystal Reports 2008 SP3 is a 32 bit application.
b) Business Objects 3.1 SP3 is a 32 bit application.
c) So, install  Oracle 10g 32 bit or 64 bit, But install Oracle 10g client connectivity software of 32 bit only to interact with Crystal Reports 2008.
d) If you want to use ODBC, you can connect using Microsoft ODBC drivers that are installed by default or you can also download Data Direct 5.3 drivers. or try this link https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/bobj_download/main.htm

Following is my environment on which connection is successful:
Operating System:   Windows 7 Ultimate (64 bit)
Database:                Oracle 10g 10.2.0.3 (32 bit)
Reporting Tool:       Crystal Reports 2008 SP3 (32 bit)
Enterprise:               Business Objects 3.1 SP3 (32 bit)

Using ODBC
1) create a 32 bit system DSN on the client machine (or the server).
    On a 64bit operating system, you will find 32 bit ODBC setup file in the following path [drive:/]Windows/sysWOW64/odbcad32.exe

2) Open Crystal reports designer tool, and try connecting to the System DSN created in step 1.  Check the following screenshot, Crystal Reports 2008 SP3, Connection tested with ODBC and it is successful on my machine.  Oh what a relief !!

SNAGHTML7fcf80

Using TNSNAMES.ORA
2) Check the following screenshot, Crystal Reports 2008 SP3, Connection tested with TNSNAMES.ORA (i.e. Oracle Server)
 

SNAGHTML772f8a

Make sure that you install all the correct 32 bit versions of Crystal Reports 2008, Business Objects 3.1 and Oracle 10g to be compatible with each other. The report should work fine in Infoview and local PC.

Share your thoughts or any alternative solutions to resolve this error. Have a Good day.!!  Smile

Advertisements

5 Comments »

  1. This works for me locally. However if I try to publish the report to Infoview and then schedule it, then it fails to open the database connection. Have you found a resolution for this issue? Please help!!

    Comment by Uttara — June 29, 2012 @ 2:31 pm

    • Hi Uttara,
      Make sure you have 32 bit native client is installed on BI Server, Developer machine. If you still see issues then check your ORACLE_HOME and TNS_ADMIN are set correctly, reboot the server.

      Irfan

      Comment by Irfan — June 30, 2012 @ 11:15 am

      • I do have the 32 bit oracle client on my local machine which is a 64 bit windows 7 OS. I went and manually set the Oracle_home environmental variable though. I also went to regedit bit I cannot see the oracle home in the path HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\. Could that be a problem. If yes how to resolve this. Please suggest its urgent. Thanks!

        Comment by Uttara — July 1, 2012 @ 5:04 pm

  2. On Win7 X64, ORACLE Key is installed in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node

    Comment by Jim — July 27, 2012 @ 2:56 pm

  3. Fine way of telling, and nice piece of writing to get facts
    concerning my presentation subject matter, which i am going to deliver in institution of higher education.

    Comment by michael kors — January 9, 2013 @ 10:27 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: