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.

[david_mills02]

Hello Don

Further to my last reply, I managed to find a download for SP26 and SP27

I ran SP26 update and read your message under Release Notes "If end-user use in-place upgrading from SP25 or previous version, after upgrading, they must repair the installation in Control Panel/Programs. Otherwise the ADO.Net database connection will NOT work."

But when I click on Repair there is an error message that the feature you are trying to use is on a network resource that is unavailable

What Path should be used to be able to run the Repair?

Not knowing the Path I clicked to run the Install Program and used the Re-install option, no idea if that does the same as Repair

Thank you

Regards

David

[david_mills02]

Hi Don

Thank you for the reply

I did what I have done before, downloaded the update, clicked on it to run and let the update remove the old version and install the new version. That yesterday did not work in that when it reached myReportDocument.SetDataSource(ds) it could not connect to the database.

I needed to be able to work, so decided to uninstall SP28 and revert to SP25. I clicked on the SP28 update and chose Remove All and then ran the SP25 update - but that did not work. Crystal Reports would still not work. No idea of the error as it simply crashed with no error message - it appeared that after I ran the SP25 update having run the Remove All for SP28 that I was still using the SP28 files.

Eventually for the lack of any other idea I had to run Restore to a point before the SP28 Restore point and that eventually took me back to where SP25 was installed. Clearly not an ideal way to solve the problem

When you say "change your app.config file and remove the legacy mode" = where and how?

When you say "repair CR Designer and it must be CR 2016 SP 4 or above and CR 2013 SP 10 or above" = where and how?

Is it better to uninstall SP25 first and then run the SP28 install rather than leaving SP28 to remove SP25.

Given the time I wasted yesterday in restoring the computer I am reluctant to try installing SP28 again without knowing it will work

I am using
.Net Framework 4.8
Windows 10 64 with the latest update installed this week Version 2004 OS Build 19041.450
Visual Studio Version 16.7.1

I opened the app.config file in the project folder the only mention of Legacy version I find is

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8"/>
  </startup>

Is that what needs to be changed?

The crdb_ado.dll file that i found is
C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86
product version 13.0.25.3158
date modified 15/05/2019

You say it should be 13.0.4000.0 = would that not have updated with the install of SP28? If not how do I update the files that you say should be 13.0.4000.0?

Regards

David

[former_member11696]

Hi David and Anders,

Actually there is an update, change your app.config file and remove the legacymode.

Be sure all CR Assemblies are now 13.0.4000.0 also.

And CRDB-ADO.dll was reversioned to 13, requires a repair depending how you upgraded.

You should also repair CR Designer and it must be CR 2016 SP 4 or above and CR 2013 SP 10 or above.

Don