CR2008 MySQL ODBC Stored Procedures Parameter Entry Not Showing

[Former Member]

MySQL Server 5.0.45

MySQL ODBC 5.1.0

Creating Blank Report, Attaching with ODBC. I can see my stored procedures; however, when I click on > to add to my report ("database expert screen") I am not prompted for "Enter Parameter Values dialog box ". Instead error is reported "Database Connector Error: 'HY0000:[MySQL][ODBC 5.1Driver][mysqld-5.0.45] Incorrect number of arguments for PROCEDURE bla.bla; expected 7, got 0 [Database Vendor Code: 1318]"

Obviously need for parameters is recognized but 'Enter Parameter Values dialog box' referenced in help screen below is not executing. Any Information would be appreciated.

Selecting an SQL stored procedure and changing parameters

[Former Member · Accepted solution]

Try to use the latest DataDirect Drivers 5.3 for Crystal 2008 and check the connection.

You can download it from following link

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11484] [original link is broken] [original link is broken] [original link is broken];

regards,

Raghavendra

[Former Member]

Thought I might as well copy the "work around" here to save others from having to find it:

[7 Nov 12:47] Alex Brown

Hi Low,

I have had the same problem but have found a bit of a work around from within Crystal...

Within the Database Expert under your connection there should be AddCommand. When you add

this you can pass in your sql "call sp_testcrystal('param1','param2')"

Once this is done you will be able to expand the sp as you would a table, and using the

select expert you can filter for the results you want.

Hope this helps

Alex

[Former Member]

I believe that I have discovered the answer. Problem with MYSQL server versions before 6.0. See http://bugs.mysql.com/bug.php?id=36162

fd

[Former Member]

Thank You for Response. Please note that db is MSQL. The data direct app note does not list MySQL as supproted db. Is that correct ?

thanks

fd