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

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