|
Home > Archive > BizTalk Server General > June 2005 > Why does Biztalk use DTC?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Why does Biztalk use DTC?
|
|
| Neal Walters 2005-06-23, 5:55 pm |
| My understanding from old VB6/COM classes is that DTC (Dynamic Transaction
Coordinator) is for two-phase commits.
Why does Biztalk 2004 have a strong dependency on DTC? Even to retrieve
data, it seems to require some type of hook to DTC.
We have had problems in the past that if DTC didn't come up in the right
order with SQL, then Biztalk cannot communicate with SQL. It has also been
an issue when trying to talk to SQL 2005 from Biztalk 2004 (Yes, it works
when DTC works - see my other post).
Neal Walters
http://Biztalk-Training.com
| |
| Jon Flanders[MVP] 2005-06-23, 5:55 pm |
| Most transactions biztalk has with sql server are local transactions. They
only use DTC when necessary - which is if there potentially could be
updating multiple sql servers (which is possible depending on your
configuration)
--
Jon Flanders
http://www.masteringbiztalk.com/blogs/jon/
"Neal Walters" <NealWalters@discussions.microsoft.com> wrote in message
news:4B43DEE0-5A05-453A-8DE8-4AE888E720F7@microsoft.com...
> My understanding from old VB6/COM classes is that DTC (Dynamic Transaction
> Coordinator) is for two-phase commits.
>
> Why does Biztalk 2004 have a strong dependency on DTC? Even to retrieve
> data, it seems to require some type of hook to DTC.
>
> We have had problems in the past that if DTC didn't come up in the right
> order with SQL, then Biztalk cannot communicate with SQL. It has also
> been
> an issue when trying to talk to SQL 2005 from Biztalk 2004 (Yes, it works
> when DTC works - see my other post).
>
> Neal Walters
> http://Biztalk-Training.com
| |
| Niklas E 2005-06-26, 5:52 pm |
| I guess that could be a case when you use the SQL adapter to a non-local
server or if you have the BizTalk databases on a separate server for
security reasons or if you have a BizTalk farm pointing to the same
Management DB.
Best regards
Niklas Engfelt
"Jon Flanders[MVP]" <jon.flanders@gmail.com> wrote in message
news:%23w2dBUBeFHA.688@TK2MSFTNGP14.phx.gbl...
> Most transactions biztalk has with sql server are local transactions.
> They only use DTC when necessary - which is if there potentially could be
> updating multiple sql servers (which is possible depending on your
> configuration)
>
> --
> Jon Flanders
> http://www.masteringbiztalk.com/blogs/jon/
>
> "Neal Walters" <NealWalters@discussions.microsoft.com> wrote in message
> news:4B43DEE0-5A05-453A-8DE8-4AE888E720F7@microsoft.com...
>
>
|
|
|
|
|