Skip to Content
avatar image
Former Member

Database Connectivity issue using SQL server

We have a Crystal reports 8.5 and it is working fine with SQL server 2008 R2. Now we are trying to upgrade SQL server 2012 64 bit in a new server and copied around 600 reports to the new server. But my Crystal report developer says that we have to manually open all 600 reports and change the server name and Database name.

Do we have any smarter way to accomplish?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 25, 2017 at 08:21 PM

    Yes, upgrade to CR 2016 so you only have to update each report once. CR 8.5 was never tested against SQL 2012, no idea if the reports will function the same way and you should be updating to the MS SQL Native 10 Client which CR 8.5 has absolutely no idea how to handle the new driver.

    CR 8.5 has been out of support for 15 years now, it really is time to upgrade, and it's not that expensive.

    https://www.sap.com/products/crystal-reports.html

    The biggest issue is in CR 9 all DB drivers were rewritten and the only way to update them is to open each report and Set Location from the menu drop down option and then verify each report still works with the updated Client and DB.

    You could write and application using the .NET SDK but for 600 reports it would be easier to fix each report manually. Unless you know a way of validating the data in code.

    But I doubt being in a supported environment is something you want to do since you have not upgraded CR in 17 years.

    Good luck

    Don

    Add comment
    10|10000 characters needed characters exceeded