symptom (of an illness)

Error: “Failed to load database information details: database connector crdb_bwquery.dll could not be loaded” in Crystal Reports 2011 with old report. The newly created report works fine using the “SAP BW MDX Query Driver”.

environment

Crystal Reports 2011 SAP BW 7.x

Copy this question

Start Crystal Reports 2011 Designer and connect to SAP BW system, the report is saved in step 2 Refresh the report. i Display the error message “Failed to load database information details: database connector crdb_bwquery.dll could not be loaded”.

result in

crdb_bwquery. dll is used by the legacy SAP BW query drivers that are no longer available from Crystal Reports 2011. They were provided in CR 2008 so that already created reports using the legacy drivers can still be used, and the reports can be recreated using the new drivers. “SAP BW MDX Query Driver”

resolutions

1. Open the report in the Crystal Reports 2008 or 2011 designer. Browse Database -> Set the data source location. Create a new connection using the “SAP BW MDX Query Driver”. Under the newly created connection, browse to the query used in the current reportClick update. If there are variables in the query, they will be prompted. Map the required fields that are handled or fetched differently by the new driver. Execute the report. </ ol>

Note: Mapping fields can be complicated because the two drivers treat back-end objects like hierarchies differently, and in some cases, re-creating the report is the only option. In some cases, field names and types also change, so some formulas may need to be type-converted before the report can fetch data.

keywords

crdb_bwquery. crdb_bwquery. cr2011 database error, sap bw mdx query driver, sap bw query driver

symptom (of an illness)

Error: “Failed to load database information details: database connector crdb_bwquery.dll could not be loaded” in Crystal Reports 2011 with old report. The newly created report works fine using the “SAP BW MDX Query Driver”.

environment

Crystal Reports 2011 SAP BW 7.x

Copy this question

Start Crystal Reports 2011 Designer and connect to SAP BW system, the report is saved in step 2 Refresh the report. i Display the error message “Failed to load database information details: database connector crdb_bwquery.dll could not be loaded”.

result in

crdb_bwquery. dll is used by the legacy SAP BW query drivers that are no longer available from Crystal Reports 2011. They were provided in CR 2008 so that already created reports using the legacy drivers can still be used, and the reports can be recreated using the new drivers. “SAP BW MDX Query Driver”

resolutions

1. Open the report in the Crystal Reports 2008 or 2011 designer. Browse Database -> Set the data source location. Create a new connection using the “SAP BW MDX Query Driver”. Under the newly created connection, browse to the query used in the current reportClick update. If there are variables in the query, they will be prompted. Map the required fields that are handled or fetched differently by the new driver. Execute the report.

Note: Mapping fields can be complicated because the two drivers treat back-end objects like hierarchies differently, and in some cases, re-creating the report is the only option. In some cases, field names and types also change, so some formulas may need to be type-converted before the report can fetch data.

keywords

crdb_bwquery. crdb_bwquery. cr2011 database error, sap bw mdx query driver, sap bw query driver