Pulpcore: Hello world tutorial »

Crystal Reports Tip: crdb_oracle.dll could not be loaded

At work recently I had to use Crystal reports
We where using it to connect to an Oracle database and generate a report which was then displayed from an ASPX page.

Both of these installs failed at first with the error:
“The database dll ‘crdb_oracle.dll’ could not be loaded”
Here is a check list of things to try.

  1. Check that crdb_oracle.dll is installed. By default in the Crystal Reports 10 install that I had Oracle was not installed. To fix it run the installer and pick Oracle from the list of items to install.
  2. Check you have the Oracle client tools installed. I remember vaguely it had to be version 9.2 upwards.
  3. Check your PATH variable. If you have more than one version of the Oracle client tools installed I have read that Crystal reports will use the first one it finds set in the PATH variable. Make sure it is the correct version for the database your report needs to connect to.
  4. Check that the IIS user that runs your reports has access to your Oracle client install. Parent directory’s count too from my experience.
  5. Check that the IIS user that runs your reports has access to the crdb_oracle.dll

    6. Checking these things fixed both installs. Both times it was a problem with the IIS user not being able to get to either the Oracle or Crystal report dll’s.

Tags:

This entry was posted on Wednesday, February 6th, 2008 at 10:21 pm and is filed under Crystal Reports. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Crystal Reports Tip: crdb_oracle.dll could not be loaded”

  1. Tom Says:
    February 22nd, 2008 at 11:12 pm

    Great help. I uninstalled another Oracle product and it removed the path entry. Adding back the oracle_home\bin to the path fixed it.

  2. khiem congnghia Says:
    March 11th, 2008 at 4:42 pm

    Hello,
    I have a same problem when i try to call a crystal report (v11) from a winform. But this error only occurred when i pass value to parameter field, such as: myReport.SetParameterValue(”PARA_NAME”, “VALUE”). Please tell me why?

Leave a Reply