We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

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

Pyazilim
Pyazilim asked
on
Medium Priority
5,651 Views
Last Modified: 2008-01-09
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

Comment
Watch Question

Author

Commented:
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
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
>>Is it possible to change the connection provider info of a report dynamically
As far as Iknow you cannot change the connection tyoe dynamically.

This tool may be able to help
http://www.softwareforces.com/Product/ri/pro/3/rptinspector.htm

mlmcc

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.