When attempting to create a Crystal 10 report based on MySQL 4.1.7, the following error message appears:
"Failed to open a rowset. Details: 23000:[MySQL][ODBC 3.51 Driver][mysqld-4.1.7] 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 '(('kiwi_blat'.'DLOADS' 'DLOADS1' INNER JOIN 'kiwi_balt'.'DLISTS''DLISTS1' ON 'D' at line 1"
To resolve this issue, upgrade to MySQL 4.1.8.
MySQL is not an officially supported database in Crystal Reports 10. For a list of supported databases, please refer to Crystal Reports 10 Supported and Tested Platforms.
MY SQL SYNTAX CHECK MANUAL RIGHT USE NEAR ERROR MESSAGE Crystal Reports MySQL Database Creating Reports , c2019447 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem