Crystal Report - Oracle Connection problem on windows server 2003 64 bit

[Former Member]

Hello ...

I am using Crystal Reports 10 with Oracle Client 10.2.0.1 x64 and Visual Studio 2005 (framework .NET 2.0) on windows server 2003 x64. And I have also installed Oracle Data Access components and new service pack for Crystal report to my computer.

But I have problem in the Crystal Reports part. When I try to connect Oracle from Crystal Report, an error appears like that:

"Failed to load database information. Details: The database DLL 'crdb_oracle.dll' could not be loaded ....".

I research this error on the crystal reports forums, oracle forums, msdn forums and another places. There are some solutions for this error. I tested those. But they couldn't solve my problem.

These solutions like that :

(I give these solutions for that someone can meets that error another time and wants to solve it. May be work on him)

1) Use of brackets (parenthesis) in file / folder names in Windows (Program Files (x86)) can cause that problem.

I change the installing folder for Crystal reports and Oracle (Like Program Files x86). But it didn't work.

2) Give the full permissions to Oracle folder and Temp folder for ASPNET, NETWORK users.

I give full permissions . But it didn't work.

3) Find the CRDB_ORACLE.dll in the Crystal Reports installation folder and copy it to all bin folders in Crystal Reports path.

I do it. But it didn't work.

4) This issue is Oracle bug 3807408 and can be fixed by applying 10.2.0.1 Patch 6.

I download this patch from Metalink. But it didn't work.

What can I do ? Do you have any ideas for this error ?

Or, is there anybody meets this error and solves it ?

(NOTE: I also test it with Crystal Report 11, but the result is same. Error ... )

Thanks ...

[former_member11696 · Accepted solution]

Hello,

You wrote: To use oracle client 32 bit on the x64 server may be a problem for the next times. And my project leader don't want to change oracle client version (x64). So I try to change my reports connections to ODBC type.

There is no work around, CR will only work with the 32bit client. ODBC is still using the 64 bit client. CR is a 32bit app and therefore must use 32 bit components. Unless Oracle has a way for 32 bit apps to see their 64 bit client as a 32 bit client CR will not work with it.

There may be one work around, Start the ODBC Admin in the \system32 folder and add your DSN there. If it works then in theory Oracle will work also.

If that does not work then only option is to use the 32 bit client.

[Former Member]

I solved the problem for ODBC connection on 32 bit.

For oracle connection, DataBaseName part will exist and its value will be empty. On the other hand, report can't connect successfully.

...

ConnectionInfo connectionInfo = new ConnectionInfo();

connectionInfo.DatabaseName = "";

connectionInfo.ServerName = serverName;

connectionInfo.Password = pwd;

connectionInfo.UserID = uID;

...

[Former Member]

Thanks a lot for replies ...

To use oracle client 32 bit on the x64 server may be a problem for the next times. And my project leader don't want to change oracle client version (x64). So I try to change my reports connections to ODBC type.

Now, I want to ask another question:

Firstly, I will test these changes on 32 bit. Later, I test it on 64 bit.

My report are created on Crystal reports 10, 32 bit. I change the connection type by using "Set Datasource Location" menu. I test this ODBC connection with my report on 32 bit platform. I can see the records on the Crystal Reports when I refresh my report. This is OKEY. ODBC connection is success on 32 bit.

But, in my project (this is an web application, and it is working 32 bit and 64 bit successfully), I can't see the records. I debuggged my project on 32 bit with Visual Studio. For this, I put some breakpoints on to the specific places. I watch that two records are taken from database. Everything is good. But when "reports.aspx" file opens, these records don't appear. Before changing connection type , this records were listed in my project on 32 bit.

For this, have you any ideas ?

Thanks ...

[former_member183750]

Assumption: The report you are using was built using CR 10.0 or CR XI. These versions of CR ship the crdb_oracle.dll (thus allowing a "native" Oracle connection).

.NET 2005, ships CR 10.2, which does not have crdb_oracle.dll and thus the error.

CR 10.0 will not work with .NET 2005 - at least it is certainly not supported in .NET 2005

Your only option is to convert the report to use 64 bit ODBC connection. The dll is crdb_ODBC.dll. Remeber, that you will have to create a 64 bit ODBC datasource. A 32 bit ODBC connection is no good to you when using 64 bit CR 10.2.

Ludek

[former_member11696]

Crystal Reports 10 is a 32bit application and will not connect to a 64 bit DB Server using a 64 bit Oracle Client.

Only option is to use a 32 bit client. If there are still issues then it's a thunking ( 64bit to 32 bit conversion) in the Oracle client. Contact Oracle for support.