Skip to Content

Crytal Reports - Database Connection error

Aug 15, 2017 at 07:43 PM


avatar image
Former Member

We access Crystal reports from a .net application that is running on IIS 8.0 on Windows Server 2012. These are new servers and all reports are working fine in our old environment. We copied all reports to the new env some of the reports work and some give "Database connection error". The fix is it to simply open the report and click on verify database and choose the right datasource. So if we do this in DEV the report works fine and the same report can be copied to UAT and PROD .... since it actually takes the database connection parameters from web.conf file. Since we have close to 300 reports trying to find if we are missing anything ... some kind of global setup that can be set once and fix all the reports.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Don Williams
Aug 15, 2017 at 07:45 PM

Hi Anita,

You never said how old those reports are? It could be the new OS changed the DB Client used so since rpt file keep the connection and table info it manually needs to be updated.

Search for ReplaceConnection() and you'll be able to update the connection info at runtime, save the update report once it has been updated.


10 |10000 characters needed characters left characters exceeded