Community ODBC Adapter – Schema Generation

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Community ODBC Adapter – Schema Generation

Viewing 1 reply thread
  • Author
    Posts
    • #24886

      Hi, 

      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()

      Any help on the correct syntax to use at this stage would be appreciated.

      Cheers

      Stu.

    • #24930

      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 :

      http://geekswithblogs.net/StuartBrierley/archive/2010/06/09/biztalk-2009—the-community-odbc-adapter-schema-generation-with.aspx

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.