Error in File temp_{guid} Failed to load database information SP27

[bj18]

I am running a VS2019 environment with .net 4.6. My project is Web Api and I have a library for a CrystalReports service.I am receiving the following error:

Error in File temp_66009bf9-6a2d-4184-895a-1d543ba0a14a 2672_2216_{64F682DC-D0A4-4CBE-A2CF-1B617B9251AB}.rpt: Failed to load database information.

I have installed CRforVS13SP27_0-10010309 on both my dev and prod web server. Works in dev but fails in production.

I have reviewed several posts and some have helped and some are not for my environment. For this particular issue I have not found a solution.

code:
...
var rptFile = "c:\filepath-to-webserver\app_data\crystal\CReport.rpt"

using (CReport rpt = new CReport())
{
rpt.Load(rptFile);
// dtCrystal passed in; has 1 row and System.Data.DataTable has TableName set
rpt.SetDataSource(dtCrystal); // fails here

}

I have tried many iterations without success and need some help. Thanks,

[former_member11696 · Accepted solution]

As of SP 26 we reversioned the crdb_adonet.dll so it's possible you need to uninstall the previous version first and then install SP 27.

Also, you need to remove the LegacyMode from the web.config file for database connections, no longer required for the latest Framework version.

I suggest using Fiddler to see where the web.config files are getting loaded from, typical cause is your app is loading an older config file which redirects to an older version of CR runtime.

Since it works in QA there is something on the App server that is not up to date.

Don

[former_member1005474 · Accepted solution]

Don Williams - I have the same error after upgrading from SP 24 to SP 28. "Failed to load database information". I completely uninstalled SP 24 and installed SP 28, and still getting that error. I can't find crdb_adonet.dll in the main Crystal folder. Where should it live, and why is it missing?