Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 09 Mar 2009 at 12:00pm
Is the Oracle client installed on the server where Crystal Reports Server is running? If so, does the tnsnames.ora file there contain a connection to the correct database?
Crystal's native Oracle driver provides a means for Crystal to connect to the Oracle client software - it's not a replacement for the Oracle client.
Joined: 16 Feb 2011
Online Status: Offline
Posts: 7
Posted: 06 Apr 2011 at 10:22am
Hi,
I am getting a similar error. The env we use is
BO XI SP3
crystal reports 2008
Windows 2003 Server 64 bit
The database is Oracle 9i
The Oracle client is 10g(10.2.0).
We are migrating the reports from XIr2 to 3.1. When I try to run the
migrated crystal report in 3.1 Infoview, we are getting the error as
"Failed to load Database Connection". whereas the same report works fine
in the CR Designer. We are using Oracle Server Connection in r2. The
same works fine in Designer. But when I change the connection to ODBC
and save the report back to enterprise it works fine. But we want to use
the Oracle Server Connection.
I tried to give the default print settings as you had suggested. But it's not getting resolved.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 06 Apr 2011 at 10:55am
You need to make sure that you have the 32-bit Oracle client installed on the server where BusinessObjects is running. Even though you have a 64-bit server, BO can only interact with the 32-bit version of the database client software.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 06 Apr 2011 at 11:22am
Is the TNSNames file set up the same? Can you call tnsping from a DOS prompt and connect to the database? I assume the answer to both of these is yes because you can connect via ODBC.
Do you have more than one Oracle Home? The native Oracle connection from Crystal will only see the first home.
BTW, this has nothing to do with the print settings...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum