Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction over different servers
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00952189
Message ID:
00952337
Views:
9
This message has been marked as the solution to the initial question of the thread.
Hello Martin,

distributed transaction is managed through the Microsoft Distributed Transaction Coordinator (MSDTC)

You can start by reading on this subject at :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0291.asp

I've done this a few years ago in VB6... This is fairly straightforward. What you have to do is start MSDTC (which might be stopped by default) and activate "Transaction Support" on your COM+ component... MSDTC will automatically take care of the transaction, whether it's on the same server or on different servers.

Hope that helps,

Alex
Alexandre Boudreault-Ferland
Chief Technology Officer
AZUR Technologies
http://www.xicommunity.ca
http://www.xiazur.com
http://endfunction.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform