Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Connect Crystal Report with DataSet

I have a problem when I want to connect Crystal Report with DataSet in c#.

Error

failed to load database information, details: unable to load database connector 'crdb_adoplus.dll'. the correct version of the database client for this type of database may not be installed.

Here's a Screenshot

Can you help me please?

like image 549
Mohamed Baddou Avatar asked Jan 18 '20 00:01

Mohamed Baddou


People also ask

How do I add a data source in Crystal Reports?

To select a data source you must be connected to SAP Business Objects platform server. When you go to File → New → From Data Source → Choose a data source connection dialogue box appears → Browse Repository → Data Source Type list → Select data source you want to connect → Next.

What are the data sources you can connect from Crystal?

SAP Crystal Report can connect to any data source. This platform is use to generate the reports. All can perform different work. SAP allows some connection like Universe, SAP BEx, Query Relational, Connection HANA, Excel Spreadsheets.


3 Answers

I had the same problem on Microsoft Visual studio 2019 by installing SP26 "SAP Crystal Reports runtime engine for .NET Framework (64-bit)" before "SAP Crystal Reports, version for Microsoft Studio".

The main problem is that the run-time engine doesn't copy crdb_adoplus.dll file which need to Crystal Report to load data from ADO.Net dataset.

If you also followed my installation sequence, you must:

  1. Remove "SAP Crystal Reports runtime engine for .NET Framework (XX-bit)" and "SAP Crystal Reports, version for Microsoft Studio" by the control panel.
  2. Run the "SAP Crystal Reports, version for Microsoft Studio" installer as Administrator. After the installation, it will automatically ask you to install the correct engine.

See also: Crystal Report SP26 SetDataSource() Method failed in computers of clients in Visual Studio 2019

like image 164
verronz Avatar answered Sep 30 '22 08:09

verronz


We are using Crystal Report's on 20+ server and we always install x32 and x64bit version.Today i installed SP30 from here for VS2019 https://www.tektutorialshub.com/crystal-reports/download-crystal-reports-for-visual-studio-2019/ , also today i tried to add a field to dataset and gave me 'crdb_adoplus.dll' error. After a lot of search, i installed x32 bit runtime both x64bit, it worked.

like image 41
Unknown Artist Avatar answered Sep 30 '22 10:09

Unknown Artist


I had the same problem. I uninstalled all crystal reports (for visual studio and runtime) and install only the version for Visual Studio and installed the runtime checking the last checkbox on the installation wizard (to install the correct runtime).

I think that when installing on top of an existing crystal some files are missing.

like image 22
Pablo Rausch Avatar answered Sep 30 '22 08:09

Pablo Rausch