SAP Knowledge Base Article - Public

1220387 - Error: "Failed to open a rowset".[MySQL][ODBC 3.51 Driver][mysqld 4.1.7]"

Symptom

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"

 

Resolution

To resolve this issue, upgrade to MySQL 4.1.8.

See Also

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.

Keywords

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 BusinessViews Manager , Problem

Product

SAP Crystal Reports 10.0