System.Transaction and MSDTC

[Guest]

We are developing a .NET 2.0 based distributed application and use
System.Transaction namespace to handle transaction at Business Object level.
DAAB 2.0 is used at Data Access Layer level. The database is SQL server 2000
(installed in Windows 2000 server).

The .NET server components are deployed in Windows 2003 server. When we
attempt to run the application, it throws exception saying “DTC†service is
not running. We are not sure why DTC is a prerequisite for System.Transaction
which defeats the purpose of choosing the same. We have also customized the
DAAB not to close the connection when the transaction scope is alive but it
does not help (This is implemented based on DAAB 3.0).

Will system.transaction use DTC by default with SQL server 2000? If so, is
DTC a prerequisite in this scenario? There are few articles states SQL 2005
will not require DTC. Any supporting links or inputs on this would help us.
Appreciate your help.

Thanks and Regards
Rasheed

 

[Joerg Jooss]

Thus wrote Rasheed,

We are developing a .NET 2.0 based distributed application and use
System.Transaction namespace to handle transaction at Business Object
level. DAAB 2.0 is used at Data Access Layer level. The database is
SQL server 2000 (installed in Windows 2000 server).

The .NET server components are deployed in Windows 2003 server. When
we attempt to run the application, it throws exception saying “DTC”
service is not running. We are not sure why DTC is a prerequisite for
System.Transaction which defeats the purpose of choosing the same. We
have also customized the DAAB not to close the connection when the
transaction scope is alive but it does not help (This is implemented
based on DAAB 3.0).

Will system.transaction use DTC by default with SQL server 2000? If
so, is DTC a prerequisite in this scenario? There are few articles
states SQL 2005 will not require DTC. Any supporting links or inputs
on this would help us. Appreciate your help.

Yes, System.Transactions uses the DTC when accessing SQL Server 2000.

See http://msdn.microsoft.com/msdnmag/issues/05/02/DataPoints/default.aspx
for more information.

Cheers,

 

[Guest]

Joerg Jooss,

Thank you. This information helped me to understand the facts! Sincerely
appreciate your feedback,

Thanks,
Rasheed