sql adapter always using dtc

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › sql adapter always using dtc

Viewing 1 reply thread
  • Author
    Posts
    • October 5, 2006 at 11:24 AM #15969
      community-content

        When I use the sql adapter on a remote sql server it fails when dtc is turned off.  I am only doing a select statement and am not sure why it wants to perform a transaction.  Is there a way to supress this behavior

      • October 9, 2006 at 5:58 PM #15995
        community-content

          I’m not a huge SQL Adapter expert.  I’d guess no.

           

          If you are looking for a more preferment solution you could look at using a simple .net component inside an Orchestration.  You’d have more control over the transactions.

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