Re: DTC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sam Santiago (ssantiago_at_n0spam-SoftiTechture.com)
Date: 10/10/04 

Date: Sat, 9 Oct 2004 20:57:27 -0700

DTC has worked for me in the pass and I have also had my share of problems
with it. Mostly, when another DB other than SQL Server is used. What
exactly is the problem you are seeing? It could be an NLB configuration
issue more than a DTC issue. You can use separate DB and queue
transactions, but then they are separate and unrelated transactions; not 1
atomic transaction.

Thanks,

Sam 

-- 
_______________________________
Sam Santiago
ssantiago@n0spam-SoftiTechture.com
http://www.SoftiTechture.com
_______________________________
"Johan Jooris" <johan_jooris@hotmail.com> wrote in message
news:vCB8d.266854$FV6.13721699@phobos.telenet-ops.be...
> We're experiencing lots of problems with dtc's on our production servers
(2
> NLB nodes running the application and a MSCS cluster running sql and
msmq).
> The only reason we're using dtc is that msmq and database access can be
put
> in one transaction.
>
> Are there any experiences with the use of dtc or is the recommendation to
> use (managed) sqltransactions (ado.net) and messagequetransactions ?
>
>
>

Relevant Pages

  • Re: Who is using MSMQ?
    ... SQL Server is one of several services ... that sometime uses DTC to manage distributed transactions. ... to shut down DTC for whatever reason, the dependency logic listed MSMQ as ... Do you know why the SQL Server Service Manager is asking ...
    (microsoft.public.sqlserver.security)
  • Re: COM+/DTC + firewall + SQL Server = need help
    ... Configuring Microsoft Distributed Transaction Coordinator (DTC) to ... Since you are only using one SQL Server, why are you using COM+ distributed ... If you have no need for a distributed transaction stop using transactions ...
    (microsoft.public.sqlserver.security)
  • RE: EventID 4689, 4444, 4437
    ... Any suggestions re the MS DTC ... ... Help & Support Center found five KnowledgeBase articles, ... Another COM+ related error message also registered, ... Inbound Distributed Transactions using Native MSDTC Protocol = 0, ...
    (microsoft.public.windowsxp.general)
  • Re: Why does Biztalk use DTC?
    ... Most transactions biztalk has with sql server are local transactions. ... > My understanding from old VB6/COM classes is that DTC (Dynamic Transaction ...
    (microsoft.public.biztalk.general)
  • RE: HA Cluster & XA Transactions
    ... dll in every node that has an instance of sql server running. ... possible the transactions may become indoubt if the current node goes down ... As to the other DTC question, you should try the DTC forums. ...
    (microsoft.public.sqlserver.jdbcdriver)