Transaction Server

[George Varelas]

Imagine that we have one SQL server 2000 and 2 databases A and B. Obviously
I need two connections. I want to implement a transaction that controls two
insertions, one in each database. The transaction commits when both the
insertions are succesfull. I know that I need MSDTC. Is it enough to start
the appropriate service. If yes could someone give me a code sample that
implements this transaction with the MSDTC as intermediate in C#. That would
help a lot.

Thank you in advance

 

[Trapulo]

Imagine that we have one SQL server 2000 and 2 databases A and B. Obviously
I need two connections. I want to implement a transaction that controls two
insertions, one in each database. The transaction commits when both the
insertions are succesfull. I know that I need MSDTC. Is it enough to start
the appropriate service. If yes could someone give me a code sample that
implements this transaction with the MSDTC as intermediate in C#. That would
help a lot.

Thank you in advance

Search in msdn docs about COM+ and enterpriseservices (using COM+ from NET).
It is very simple (the transactions are declarative)

 

[Angel Saenz-Badillos[MS]]

The only complicated part about using distributed transactions with ado.net
is going to be the setup, take a look at the following article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/disttranvbnet.asp

Make sure you understand the properties, the most usefull are
<Transaction(TransactionOption.Required)> and <Autocommit>