Skip to Content

Failed to load database information

Hi, everyone.

We are having problem connecting reports to database in server. When we open the report, we get the "failed to load database information." These reports only work on our local machines.

We installed Crystal Report 32-bit SP25 runtime engine on the production server. It is the exact same one we installed on our local machines for development. We are using Oracle database. We configured ODBC's System DSN to match the connection string in Web.config. Same setup as our local machines.

We are not sure how to resolve this error. Please help.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 07, 2019 at 04:47 PM

    I got the problem solved by doing this:

    Run IIS as administrator.

    Go to your Application Pools > Advanced Settings.

    Set Enable 32-Bit Applications to True.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 06, 2019 at 06:27 PM

    For Oracle, you need to make sure that you have the 32-bit version of the client software installed. Also, from experience, I highly recommend using the Native Oracle connection type instead of ODBC because it's faster and more reliable. If you have to use ODBC, DO NOT use Microsoft's Oracle ODBC connector - you need to use the one from Oracle instead. You also need to make sure that you have 32-bit ODBC connections configured and not 64-bit ODBC.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

    • We did CRLogging and got the error "The specified DSN contains an architecture mismatch between the driver and application." We are going to try the ODBC 64 bit and see what will happen even though our application is built for 32-bit.

      Thanks for your detailed response. At least we have some sense of direction on what we can try.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.