Understanding MSDTC in Windows.
-
Hi To use transaction construct(as follows) in C#, MSDTC needs to be running on Windows machine. Right? using (TransactionScope ts = new TransactionScope()) { using (SharedDbConnectionScope sharedConnectionScope = new SharedDbConnectionScope()) { // update table 1 // update table 2 // ts.commit here } } 1. Is MS-DTC a default service on Windows systems(XP, Vista, Windows 7, Servers etc)? 2. If it is not enabled, how can I make sure it gets enabled during the installation process of my application? Please advise. Thanks AJ
Follow your goals, Means will follow you ---Gandhi---
-
Hi To use transaction construct(as follows) in C#, MSDTC needs to be running on Windows machine. Right? using (TransactionScope ts = new TransactionScope()) { using (SharedDbConnectionScope sharedConnectionScope = new SharedDbConnectionScope()) { // update table 1 // update table 2 // ts.commit here } } 1. Is MS-DTC a default service on Windows systems(XP, Vista, Windows 7, Servers etc)? 2. If it is not enabled, how can I make sure it gets enabled during the installation process of my application? Please advise. Thanks AJ
Follow your goals, Means will follow you ---Gandhi---
You don't need it with the newer versions of SQL server like 2005 or 2008. It is only required if you are using SQL 2000. If you are using Oracle, then you need this service.
Best wishes, Navaneeth