Once again i need your help. I'm currently using CR 2008 accessing mysql database via ODBC connection. I need to use a mysql stored procedure in a report. I can see all the stored procedures in their own folder but i can't access them. The following error is shown:"DB Connector Error:'42000[MySql][ODBC 5.1Driver]You have an error in your SQL sintax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 1 [Database Vendor Code: 1064]'.

CR version: 12.0.0.683

MySQL vesion: 5.0.22

ODBC connector: MySQL ODBC 5.1 Driver

 

Hope i can get some help. Thanks in advance.

 

CP