asked on

The database DLL 'crdb_oracle.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\burak2 {3BC043CF-27DB-4C79-9079-AE224D365936}.rpt: Failed to load database information

Dear Crystal Reports Experts,

I have reports of which connection providers are native Oracle 8 Server connections. I am getting the following error while running them in my web application developed with Visual Studio .NET 2005 (Crystal Reports for Visual Studio .NET):

Failed to load database information. Details: The database DLL 'crdb_oracle.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\burak2 {3BC043CF-27DB-4C79-9079-AE224D365936}.rpt: Failed to load database information.

If I open the report in Crystal Reports (version 9.2.0.448) and change the connection from Oracle Server to OLE DB (ADO) connection, it works. Since I do not want to open each report and change the connection manually, I am looking for a way to change the connection provider programmatically. Is it possible to change the connection provider info of a report dynamically or if not, how can I get rid of the crdb_oracle.dll error?

Thanks in advance,

Burak

Pyazilim

ASKER

By the way, the machine running the reports have Oracle 9.2.0.1.0 Client installed, and the path to the oci.dll is in the PATH environment variable. I also gave the NEWTORK SERVICE account Full Control of the crdb_oracle.dll which resides in C:\Fidelio\crystal directory, which is also in the PATH

PATH=C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\
Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\
Fidelio\Crystal

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial