Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Mysql / Crystal Reports Error

Posted on 2011-03-01
4
414 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
ID: 35010643
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
ID: 35011361
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
ID: 35011728
Are using the 32 -bit drivers?

mlmcc
0
 

Author Comment

by:transstates
ID: 35035966
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 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