Since MSDTC needs quite a few ports open, is there a way to use transactions within a Windows Forms application, using ADO.NET, hitting 1 SQL server on another machine (firewalled) and not use MSDTC? Thanks
Why not just use local sql transactions? If you don't have multiple resource managers that need to be coordinated, a distributed transactions coordinator is really overkill. If you are using .NET 2.0+ you could use TransactionScope or connection.BeginTransaction() to get local transactions in the database, even from a remote windows forms application. You can read more about this here: TransactionScope: http://msdn.microsoft.com/en-us/library/ms172152.aspx SqlTransaction: http://msdn.microsoft.com/en-us/library/86773566.aspx -- Patrik Löwendahl http://www.lowendahl.net [MVP] [MCT - Enterprise Application Development] G.S. skrev: > Since MSDTC needs quite a few ports open, is there a way to use > transactions within a Windows Forms application, using ADO.NET, > hitting 1 SQL server on another machine (firewalled) and not use > MSDTC? > > Thanks
