tags:

views:

50

answers:

0
Q: 

SqlConnection and TransactionScope Timeout

I have a TransactionScope (over DTC, read committed) with a timeout of 60 minutes. In the TransactionScope I have opened the connection (I hope to enlist in the transaction) but after 30 seconds I get a timeout.

In the machine.config I changed the system.transaction maxTimeout to 60 minutes.

Why does the timeout occur after 30 seconds?

related questions

Need help with DTC error.
why do .net Database unit tests using TransactionScope and MSDTC fail ?
Under what circumstances would SQL replication partially (and silently) fail from a MSDTC Transaction from a c# application
Distributed Transaction Coordinator
WCF windows service issue with MSDTC
MSDTC (Distributed Transaction Coordinator) Service Stops Unexpectedly
Intermittent failure to enlist SSIS package in DTC transaction
MSDTC - how many ports are needed
Trace why a transaction is escalated to DTC
Msdtc Transaction
Linked Server Error using MSDTC
Transaction Scope
Read MSDTC configuration
Multiple Connections With Same Connection String Under A Single Transaction, Elevated Transaction?
MSDTC communication fails over VPN
System.Transaction implicit transaction messing with my other connections
TransactionScope Error against Sql Server 2000 - The partner transaction manager has disabled its support for remote/network transactions.
distributed transaction between two MS SQL Server 2005
How to determine whether SqlConnection is enlisted into a System.Transactions' tx or not?
MSDTC and Oracle transaction locks after abort has been called?
Can I create a Database Deadlock test in Nunit?
What's the difference between DTCPing and DTCTester?
SQL Server, Remote Stored Procedure, and DTC Transactions
How to prevent an Insert query from enrolling into a Distributed Transaction?
How do i enable MSTDC on sqlserver?