C# – SAP Crystal reports (Failed to load database information)

ccrystal-reports-2010MySQL

favorite

There is a problem i have been facing for couple of days. The problem is that i have developed C# Winform application using windows 7 professional sp1,mysql5.5 and SAP crystal report. When i deploy… and install it on the client machine then if the application finds windows 7 professional sp1 on client machine the reports are displayed very well in the application but if it finds (other than windows 7 sp1) professional on the client machine it gives error "Failed to load database information. bla bla {GUID}.rpt file" while displaying or printing. The application developed is not working on other than (Windows 7 professional sp1).

Deploying includes packages. .NET frame work 4.0 , Run time Crystal report Engine , Mysql 5.5 and VS C++ Redistributable.

Developer Machine has. Windows 7 professional sp1, Visual Studio 2010 , SAP Crystal Report for VS 2010, MYSQL Server 5.5

Best Answer

your application EXE file cannot stand alone to running it, the EXE file need the [app_name].exe.config in the same directory so the application can run and load the crystal report successfully.

so these is my conclusion:

the app.exe.config is all in one package which cannot be separated with the EXE file.
the supporting component such as dll files, app.exe.config etc CANNOT be combined into the EXE file.

You can find more in following Link

Try this also:

Add the following section to the config file:

<startup useLegacyV2RuntimeActivationPolicy="true">
 <supportedRuntime version="v4.0"/>
</startup>

The attribute will be required to view reports based on ADO.NET objects

It's all about bitness

With Access databases, you have to be careful about the bitness of your application:

There is not standard 64 bit driver for .mdb files (there is one by default in Windows for 32 bits though).
To be able to access .mdb and .accdb databases from a 64 bit application, you must have MSOffice 64 bit or Access 64 bit or the Access Database Engine drivers for 64 bit.
If you have MSOffice or Access 2007/2010/2013 32 bit installed on that machine, you won't be able to install the 64 bit driver, you can't mix and match 32 bit and 64 bit Office components.

To solve your issue

If you are using .mdb Access files, simply compile for 32 bits explicitly (not AnyCPU since it will try to launch your app as 64 bit in a 64 OS).
If you are using .accdb Access files, match the bitness of Office/Access installed on the user machine, or, if Office isn't there, install the Access Database Engine driver.
In any case, if your application is to be deployed in mixed 32 / 64 bit environments, you will need to compile explicitly for each and install the right version according to the bitness of the Access Database Engine or MSOffice installed on the user's machine.

Note: just to clarify, if MSOffice 2007/2010/2013 is already installed on the user's machine, there is no need to install the Access Database Engine.

C# – Error in Crystal Report: could not load file or assembly file’ ‘

I think you require this code, add it into your web.config

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

Pretty sure this is on google, it maybe a duplicate (will search after answering)

EDIT:

You may have to edit your .Net setting within your build configuration. Maybe try uninstalling the crystal assemblies - set .Net 4 and reinstall (assuming you weren't already on .Net 4) – n34_panda yesterday

Best Answer

Related Solutions

.net – Winforms Crystal Report – “Failed to load database information” error

It's all about bitness

To solve your issue

C# – Error in Crystal Report: could not load file or assembly file’ ‘

Related Topic