Bug #31682 update table from MS ACCESS table to mysql table using crystal report
Submitted: 18 Oct 2007 1:42 Modified: 19 Oct 2007 9:20
Reporter: s w Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.17 OS:Windows (xp)
Assigned to: CPU Architecture:Any

[18 Oct 2007 1:42] s w
Description:
hi there
i have a problem with mysql table which cannot used in crystal report.
there was a error message like:
"Query Engine Error:'HY000:[MySQL][ODBC 3.51 Driver][MySQL-5.0.45-community-nt]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 'mydb`.`mytable` LIMIT 0` at line 1'.
please help me for the problem thx.

How to repeat:
hi there
i have a problem with mysql table which cannot used in crystal report.
there was a error message like:
"Query Engine Error:'HY000:[MySQL][ODBC 3.51 Driver][MySQL-5.0.45-community-nt]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 'mydb`.`mytable` LIMIT 0` at line 1'.
please help me for the problem thx.
[18 Oct 2007 4:10] Valeriy Kravchuk
Thank you for a problem report. What exect version of MyODBC, 3.51.xx, do you use?
[18 Oct 2007 4:54] s w
i use myodbc 3.51.17.
[18 Oct 2007 11:49] Susanne Ebrecht
Hi,

to reproduce this, we need more informations:

a) what exactly did you do to get this error message?
b) please attach the sql syntax you used
c) please attach the trace file

You also use a very old MyODBC version. Please, try it with our newest versions: MyODBC 5.1 or MyODBC 3.51.21 and let us know, if the error occurs here too or if not.

Susanne
[18 Oct 2007 13:12] s w
ok
first i opened crystal report file <example: invoice.rpt> In thar .rpt file there was a template for the report but the database used MS ACCESS, i want to change the ACCESS database with MySQL database then i did this step in crystal report:
1. choose database expert
2. choose "create a new connection" then choose ODBC(RDO)
   choose my datasource name and click next then i filled the user ID and     Password
[18 Oct 2007 13:18] s w
ok
first i opened crystal report file <example: invoice.rpt> In thar .rpt file there was a template for the report but the database used MS ACCESS, i want to change the ACCESS database with MySQL database then i did this step in crystal report:
1. choose database expert
2. choose "create a new connection" then choose ODBC(RDO)
   choose my datasource name and click next then i filled the user ID and    Password after new database created, i wanted to change the old database with new database by click new table then i push ">" button, there was a database warning "the table "mytable" has already been added to this report with alias "mytable", Do you really want to add another alias to this table? i clicked yes and then the error showed up....
that's it sorry if there are confusing word T.T <still practicing english>
Thx.
[19 Oct 2007 6:19] s w
please help me for the problem, i really need it for my project.
Thx
[19 Oct 2007 6:27] s w
i have install a new version of Myodbc and that error not show anymore hehe.
thx for the suggestion now i can finish my project. Thx a lot^^
[19 Oct 2007 9:20] Susanne Ebrecht
Hello,

Many thanks for your response.

I close the bug, because it's fixed in newer MyODBC versions.

Susanne
[5 Nov 2007 13:20] Tonci Grgin
SW, can you please update us on your result with latest MyODBC 3.51 version?