Mysql / Crystal Reports Error
Posted on 2011-03-01
Whenever I try to create a report in CR 2008 I get the following errror message when trying to add a table to the report useing the standard report creation wizard:
"Database Connector Error: 142000:[MYSQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log] 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 `.<tablename> where 0=1' at line 1 [Database Vendor Code: 1064]"
When I use the ODBC 5.1 driver I get this error:
"The database table <tablename> cannot be found. Proceed to remove this table from the report?"
Before it displays any data it gives me this error, then displays my data.
I'm at a loss here!
Thanks in advance!!!