Failed to Load database information - Crystal report with XML as datasource

[Former Member]

Hello Friends:

I am getting the attached error when i try to load the Crystal Report with XML as data source.

I have designed the crystal report with the sample XML provided with XSD schema (PFA I have attached the XML and XSD). It is working as expected on design time. But it is failing when I load it from C# code.

Note: I have referred the following DLLs of version 13.0.2000.0 in my sample application.

CrystalDecisions.CrystalReports.Design.dll

CrystalDecisions.CrystalReports.Engine.dll

Please let me know what should be done in order to resolve this.

Thank you!

[former_member183750 · Accepted solution]

All I know is that you are using 'SAP Crystal Reports, Developer Version for Visual Studio .NET". No idea what service pack or what version of .NET...

So. make sure you are on SP 9:

Search for KBA 1525432 (search box is in top right corner) and follow the instructions there.

Remove your reference to CrystalDecisions.CrystalReports.Design.dll

Add the following references:

CrystalDecisions.Shared

CrystalDecisions.ReportSource

CrystalDecisions.Web (if web app)

CrystalDecisions.Windows (if win app)

I'd also recommend commenting out the export code for now; one step at a time. Get it to work in the viewer, then move on... No Big Bangs

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member]

Hi Ludek:

Thanks for your response.

I am running the Visual Studio 2010 with target framework 4.0 in a 64 bit machine.

As per your suggestion, I have downloaded and installed SP9 MSI 64 bit and in the assembly it has shown Crystal Report DLLs of version 13.0.2000.0 post the installation. As you mentioned, I referred all the DLLs in my sample application. But still I am facing the same error.

Do you have any idea on this? Please advise if I am wrong.

Thanks,

Saravana RJ

Senior Programmer

Odessa Technologies, Inc

[former_member183750]

I am assuming you are having these issues on your development computer? If that is the case, here is what I want you to do to get to SP 9:

Uninstall your current CRVS install - what ever SP it is...

Uninstall the SP9 MSI 64

Download the SP 9 Install Executable:

Run the install execustable

At the end of the install you wil be asked if yo want to install the 64 bit runtime - if you do, accept.

Now you are on SP 9. See what happens.

- Ludek

[Former Member]

Hi Ludek,

I have tried installing the Support Pack 9 which you mentioned above and it is giving the same error. I have uninstalled all other versions of CR and installed only the Support Pack 9. The result is same. Please share your thoughts on this.

Thank you so much for your response.

Regards,

Saravana RJ

[former_member183750]

Now that we have SP 9 installed, I'd like you to have a look at this wiki for troubleshooting direction.

- Ludek