Crystal Reports Issue

[Alan Horkan]

Using the latest MySQL ODBC driver and Crystal reports there are two problems when querying a MySQL database.



A) Tables take a very long time to add to a report (hours when adding multiple tables at once).

B) Once the tables are in the report attempting to retrieve data generates the following message:



Failed to Retrieve data from the database; Details: 4200:[MySQL][ODBC 5.1 Driver][mysqld-5.0.770] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘001-TTP-DEFECTS DEFECTS1’ at line 1[Database Vendor Code: 1064]



The SQL query that Crystal reports is generating is



SELECT DEFECTS1.DefectNum

FROM 001-TTP.DEFECTS DEFECTS1



Pasting that query into mySQL workbench and adding surrounding quotes to the database name as follows



SELECT DEFECTS1.DefectNum

FROM `001-TTP`.`DEFECTS` DEFECTS1



Allows the query to execute.

any Thoughts or suggestions would be appreciated