System.Transaction and MSDTC

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
Sat Mar 24 07:14:05 CDT 2007

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,
--
Joerg Jooss
news-reply@joergjooss.de

Rasheed
Tue Mar 27 21:01:36 CDT 2007

Joerg Jooss,

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

Thanks,
Rasheed

"Rasheed" wrote:

> 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
>