Failed to load database operation

[Former Member]

Hello all, T

One of our developers has an error on a new pc, with Crystal XI running on a Windows XP SP 3 machine. Whenever he tries to run a report in Crystal he gets an error of "Failed to load database information

"Details: The database connector 'crdb_oracle.dll' could not be loaded"

This only seems to happen for him when a report is ran, but he can do other work inside the program. He has uninstalled, then reinstalled the program to no avail. Trying to manually register that dll using regsvr32 also fails. We did find a link about moving a copy of the dll from the directory to overwrite a different version in the commonfiles directory, but that didn't help in the first installation. ( I believe it was a crystal 8 fix anyway )

I apologize in advance for my lack of knowledge on this product, but I hope someone can help track this error down!

Thank you,

[Former Member · Accepted solution]

This error message appears because Crystal Reports is unable to find the Oracle file Oci.dll, which is

required in order for Crystal Reports to connect natively to an Oracle database.

To resolve this error message:

1. Search your computer for Oci.dll.

2. Depending on the number of copies of Oci.dll found, complete the appropriate step:

If no copies are found, install the Oracle client.

If one copy is found, reinstall the Oracle client

If two copies are found, modify the value of the PATH system variable so that "'C:\Oracle\Bin;..." precedes "C:\OraForms\Bin;...".

Two copies of Oci.dll on one computer indicate that the Oracle Client and Oracle Forms are both

installed.

If Oracle Forms is installed first, the value of the PATH system variable is set to "C:\OraForms\Bin;...". However, when the Oracle client is subsequently installed, it is changed to

"C:\OraForms\Bin;c:\Oracle\Bin;...".

When Crystal Reports attempts to connect natively to the Oracle database, it reads the value of the

PATH variable as "C:\OraForms\Bin;", which is the Oracle Forms path, not the path to the Oracle Server connection.