1315377 - Database Connector Error:'HY000:[Crystal Reports][ODBC XML Driver]...when adding a table from an XML source using Crystal Reports

SAP Knowledge Base Article - Public

1315377 - Database Connector Error:'HY000:[Crystal Reports][ODBC XML Driver]...when adding a table from an XML source using Crystal Reports

Symptom

  • Cannot select table
  • Error:

Xml Error Message.JPG

Reproducing the Issue

  1. Create an XML file which contains a table called User
  2. Create a new Crystal report based on this XML file using an ODBC connection
  3. Select the table User

Crystal Reports 2008

Data Direct  Driver 5.3

Cause

This happens because the word User is a reserved keyword.

Resolution

The word User should be placed between double quotes as follows: "User"

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0