Solved

Mysql / Crystal Reports Error

Posted on 2011-03-01
4
416 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

730 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