Failed to load database information

[former_member614478]

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.

[former_member614478 · Accepted solution]

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.

[DellSC]

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

[former_member614478]

Hi, Dell.

We have 32-bit version installed. We also used the Oracle ODBC and configured DSN with 32-bit ODBC, not 64-bit. We tried to use Oracle direct connection but that didn't resolve the issue (not sure if we did that correctly). Do you have resources we can read about in regard to Native Oracle connection? Or any other possible solutions?

[DellSC]

Unfortunately, I don't have any documentation about using Oracle with Crystal - I had someone teach me how to do it many years ago.

For the Oracle Client, I know that you have to do a custom install of the client - I've never been able to get the "InstantClient" to work correctly. The options I check when I do this install are:

Oracle Database Utilities
Oracle Java Client
Oracle Call Interface
Oracle Net
Oracle SQL Developer (so I can test connections!)

You could also install the Oracle ODBC Driver.

After the install, you need to make sure that you have a tnsnames.ora file which contains the connection information for your database(s). When I have reports in multiple environments (dev, test, prod, etc.), I will use the same aliases in the tnsnames file in every environment and point them to the correct databases for that environment. That way I don't have to use Set Location in Crystal to change the data connection when I promote the report.

-Dell

[former_member614478]

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.