SP28 FAILS TO CONNECT TO DATABASE

[david_mills02]

I was on SP26 and downloaded and installed SP28 for Visual Studio (latest version) and with SP28 it now shows an error when setting the database connection

myReportDocument.SetDataSource(ds)

What has changed with SP28 from SP26 to cause the connection to fail?

thank you

[anders_gustafsson]

What is the error you see and what is the database (driver)? As far as I can see are there no database driver updates between SP26 and Sp28.

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

[former_member11696 · Accepted solution]

No, the 13.0.4000.0 is the framework version of the Assemblies.

13.0.25.3158 is the dll version and that is SP 25.

If you don't have a legacymode in your app.config file then nothing to change.

Just to be clear, when you said "Crystal Reports would still not work" are you talking about CR Designer?

So if you have CR Designer installed it needs to be repaired after uninstalling the runtime.

OK, so enable CRlogger, search for it using Google. It will generate a CR database log file which should indicate what the issue is.

Also, your app platform, x86 or x64 requires the same DB client to be installed.

Failed to connect typically indicates your data source (DS) doesn't match the reports saved data source structure.

Quick test, save the DS into a XML file and then from CR DEsigner try using Set Location to the XML file using ADO.NET (XML) driver, if there is an issue with table or field matching it may show there.