Click here to Skip to main content
15,921,382 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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.
Posted

When you set up the Stored Procedure make sure you are entering all the parameter defaults. Dont leave any parameter empty or null. This may cause a problem in setting up the Stored Procedure on the report. Then when you run the report, you can pass any parameters you want.

Thanks
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900