1594651 - CRVS2010 - Error: 'Failed To Load Database Information' when using Legacy XML driver and XML file as a datasource

SAP Knowledge Base Article - Public

1594651 - CRVS2010 - Error: 'Failed To Load Database Information' when using Legacy XML driver and XML file as a datasource

Symptom

  • Report is created in Crystal Reports 2008 and works with no errors
  • Running the same report in Visual Studio 2010 - Using Crystal Reports for Visual Studio 2010 results in the error:

Failed To Load Database Information

Environment

  • VS2010
  • CRVS2010

Cause

  • If when the report was created and the Native XML driver was selected the report uses crdb_xml.dll driver
  • Crdb_xml.dll is not included with CRVS2010

Resolution

Convert the report to use the crdb_adoplus.dll driver, in the Designer it is shown as ADO.NET (XML)

When doing so and your original xml source had a hierachal data structure CR requires you to link the tables.

You need to be able to link the tables, or "flatten" the data structure.

Possible solution and not tested:

Add a field to each table called "internal_ID" and place a number starting at 1 and incrementing for each row. This is what the legacy driver did to link the tables.

You may now be able to set location without the Designer or the SDK report an error.

Note: currently working on a supported conversion solution

We have since included a separate download to continue to use the legacy XML driver which you can get from here:

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

 

Keywords

data source CR2010 2010 CR4VS2010 CR4VS VS2010 NET2010 crystal reports for visual studio 2010 crforvs 13 crdb_xml , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio