Solved

Mysql / Crystal Reports Error

Posted on 2011-03-01
4
409 Views
Last Modified: 2012-05-11
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-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!

Any ideas?

Thanks in advance!!!

jb
0
Comment
Question by:transstates
  • 2
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
According to this document for Cystal 2008 supported platforms, you can use the MySQL ODBC 5.1
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30da6fbd-7d4f-2d10-a38c-96596304586b?QuickLink=index&overridelayout=true

mlmcc
0
 

Author Comment

by:transstates
Comment Utility
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?"  
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
Are using the 32 -bit drivers?

mlmcc
0
 

Author Comment

by:transstates
Comment Utility
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
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now