transstates
asked on
Mysql / Crystal Reports Error
Good Afternoon,
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-comm unity-nt-l og] 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!
Any ideas?
Thanks in advance!!!
jb
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-comm
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!
Any ideas?
Thanks in advance!!!
jb
ASKER
No matter what driver I try. I get the same error. The second one.
"The database table <tablename> cannot be found. Proceed to remove this table from the report?"
"The database table <tablename> cannot be found. Proceed to remove this table from the report?"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Driver was setup using RDO and not ADO. We changed the driver out and now the report works fine. Thanks for taking the time trying to help.
jb
jb
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30da6fbd-7d4f-2d10-a38c-96596304586b?QuickLink=index&overridelayout=true
mlmcc