CODEWITHSUNDEEP
mysqlodbcbiztalkbiztalk-2009
Stuart Brierley
Stuart Brierley

Reputation: 11

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?

Upvotes: 0

Views: 1060

Answers (2)

Stuart Brierley
Stuart Brierley

Reputation: 11

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

Upvotes: 0

Wrikken
Wrikken

Reputation: 70460

SHOW CREATE PROCEDURE addupdate_product; doesn't tell you which parameters to provide, or are they not coming through?

Upvotes: 1

Related Questions