mysqlodbcbiztalkbiztalk-2009

BizTalk 2009 Community ODBC Adapter - Generating Schemas from MySQL Stored Procedure

I am am currently trying out the Community ODBC Adapter (from TwoConnect) to call stored procedures on a MySQL database.

I have been able to use the MySQL ODBC driver to connect to the database, but when generating the schemas for a stored procedure with input parameters I am getting the following error:

Incorrect Number of arguments for Procedure addupdate_product; expected 7, got 0

This error occurs following the press of the Generate button, with the Query:

addupdate_product()

How to correct the syntax?

Solution

  • I have now figured out how to use the ODBC Adpater with a MySQL stored procedure that has parameters.

    The key to this is not selecting the stored procedure option and instead using the SQL Script option.

    Full details can be found here :

    Link