Print Page | Close Window

CR 2008 and MySql Stored Procedures

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4507
Printed Date: 28 Apr 2024 at 9:28pm


Topic: CR 2008 and MySql Stored Procedures
Posted By: CarlosP
Subject: CR 2008 and MySql Stored Procedures
Date Posted: 10 Oct 2008 at 11:58am
Hello guys,
 
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
 
 


Print Page | Close Window