Bug #70242 Can't use stored procedures in Crystal Reports 2008
Submitted: 4 Sep 2013 18:09 Modified: 5 Sep 2013 21:31
Reporter: Guido Mourelle Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:ODBC 5.2 OS:Windows
Assigned to: CPU Architecture:Any
Tags: connector, crystal, stored procedures

[4 Sep 2013 18:09] Guido Mourelle 
Description:
I have 

Windows XP Professional
Crystal Reports 2008
MySQL 5.6 (Windows)
mySQLODBC 5.2

Try and connect to the stored procedure and you get the error;

Database connector error HY000:[MySQL][ODBC 5.1 Driver][mysql-5.0.51a community-nt-log]incorrect nummber of arguments for PROCEDURE mobile_active_dw.test;expected 1, got 0;[Database Vendor Code 1318]

Database connector error '42S02.[MySQL][ODBC 5.2 Driver][mysqld-5.6.11]Table'modeevaluador.test' doesn't exist.

Stored Procedure

CREATE DEFINER=`root`@`%` PROCEDURE `test`(
  testparam int
)
SELECT *
FROM resulttemplate

This query returns several Data Types(int, string, datetime).
When the data type is INT Crystal throw this error but when the data type isn't INT the connection is ok.

How to repeat:
I tried very simple procedures and still got this error.
[4 Sep 2013 20:33] MySQL Verification Team 
Please check if related with http://bugs.mysql.com/bug.php?id=15975 . Thanks.
[5 Sep 2013 14:09] Guido Mourelle 
Sorry.
This bug is not related with http://bugs.mysql.com/bug.php?id=15975

The problem is the connection between Crystal and MySql
[5 Sep 2013 21:31] MySQL Verification Team 
Thank you for the feedback. Duplicate of http://bugs.mysql.com/bug.php?id=36162 .