SAP Knowledge Base Article - Public

3327382 - CR XML ODBC driver missing after installing Crystal Reports

Symptom

  • CR XML ODBC driver missing.
  • In Microsoft ODBC Data Source Administrator, the CR XML ODBC Driver is not listed.
  • Installing Crystal Reports 2020 on a computer, does not install the CR XML ODBC Driver.
  • When refreshing a report based on XML data source, it fails in Crystal Reports 2020.
  • The same report based on an XML data source refreshed successfully in older version of Crystal Reports. 

Environment

  • SAP Crystal Reports 2020

Reproducing the Issue

  1. Install Crystal Reports 2016, or earlier.
  2. In Microsoft ODBC Data Source Administrator, create an ODBC DSN to XML using the ODBC driver: CR XML ODBC Driver
  3. In Crystal Reports, create a report based on an ODBC DSN.
  4. Add at least one database field to the report.
  5. The report refresh successfully.
  6. Save the report.
  7. On a computer with Crystal Reports 2020 installed, open a report based on XML that was created in earlier version of Crystal Reports.
  8. When refreshing the report, it fails.
  9. In the Microsoft ODBC Data Source Administrator, the CR XML ODBC Driver is not listed.

Cause

  • Crystal Reports 2020 does not install a CR XML ODBC Driver, because Crystal Reports 2020 is a 64bit application, and the third party provider for the XML ODBC driver that was installed with older versions of Crystal Reports, does not have a 64bit version of the XML ODBC driver.

Resolution

  • In Crystal Reports 2020, to connect to XML, use the direct connection: XML and Web Services
      
  • For reports created in older version of Crystal Reports that used the CR XML ODBC driver, perform a set datasource location to the connection: "XML and Web Services"
      
    1. In Crystal Reports, open a report based on an XML data source using the CR XML ODBC Driver.
        
    2. Under the menu "Database", select "Set Datasource Location..."
        
    3. In "Set Datasource Location", in the section "Replace with", expand "Create New Connection"
         
    4. Under "Create New Connection", double click on: "XML and Web Services"
        
    5. In "XML and Web Services", point to the XML data source the report was based on, and click "Finish"
        
    6. In the section: "Current Data Source", select the report ODBC connection. ( Yellow cylinder )
        
    7. Click the button: "Update"
        
    8. Click "Close"
        
    9. Save the report. 
        
      Now the report uses the XML and Web Services connection.

Keywords

CR, XML, DataDirect XML ODBC driver , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2020