New connection and DTS

[Avi]

Hi all,

How do I prevent new connections inside a TransactionScope from going up to
the DTS?

using (TransactionScope scope = new
TransactionScope(TransactionScopeOption.Required))

{ Open connection here }



Thanks,

Avi

 

[Nicholas Paldino [.NET/C# MVP]]

Avi,

Are you saying you want the connection to participate in the
transaction, but you don't want it to use DTS? Whether or not it uses DTS
completely depends on a number of factors.

For example, if you are not using SQL Server 2005, then you can't
possibly use kernel mode for the transaction, as SQL Server 2000 doesn't
support kernel-mode transactions.

If you are not using MARS on the connection, and you issue another query
against an open connection in a transaction (say you have a data reader open
and you issue another query) , then you are going to start DTS.

Can you give more information about the setup you have and the
connections you are establishing?