SQL adapter calling a StoreProcedure which calls another store procedure in another server using link server

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL adapter calling a StoreProcedure which calls another store procedure in another server using link server

Viewing 1 reply thread
  • Author
    Posts
    • November 30, 2006 at 5:57 AM #16630
      community-content

        HRESULT="0x80040e14" Description="The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction."
        HRESULT="0x80040e14" Description="OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]."
        HRESULT="0x80040e14" Description="[OLE/DB provider returned message: [Microsoft][ODBC SQL Server Driver]Distributed transaction error]"

         

        Hi All,

        I get the above error.

        I am trying to call a sp using SQL send adapter, that sp calls another sp in another server using link server.

        When i run the sp using sql query analiser the sp works fine. but calling the sp from biztalk2006 sql send adapter throws the above error.

        Any help / guidence is much appreciated.

        Thanks in advance.

         

      • December 2, 2006 at 2:01 PM #16671
        community-content

          I think there is something about this in the Help Guide.

           

          I think it’s something about the transactions the adapter uses.  It can’t have inner transactions.  I could be way off…  I think it is cover dint he SQL Adapter – Receive Location section of the docs.

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