SQL Adapter Stored procedure issue

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adapter Stored procedure issue

Viewing 1 reply thread
  • Author
    Posts
    • October 18, 2006 at 5:21 AM #16087
      community-content

        Hi!

        I get the following error message when I use the SQL Adapter to run a stored procedures :

        "HRESULT="0x80040e14" Description="The request for procedure 'acuheader' failed because 'acuheader' is a table object."

        The acuheader is a table located in a different schema than the sp.  The user running the sp is dbowner in the database.

        I've run out of ideas. Anyone got one?????

         

         

         

      • October 18, 2006 at 4:44 PM #16100
        community-content

          Interesting.  So if you look at the schema you used for the SQL script (the one that got auto generated, that you should have chosen within the SQL Adapter send port configuration) does the "script" in the XSD look correct?  That is, is it calling the procedure you expect?

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