HOW TO CHANGE MSDTC SETTINGS PROGRAMMATICALLY

COPY FOLLOWING SCRIPT TO NOTEPAD AND SAVE IT AS .VBS FILE ‘Read all settings from comamnd window’This script takes 4 params,1 st param=networkDtc,2nd param=DtcAuthenticationMode’3rd param=EnablexaTransactions,4 th param=Restart DTC EnableNetworkDTC = WScript.Arguments.Item(0)DtcAuthenticationMode = WScript.Arguments.Item(1)EnablexaTransactions=WScript.Arguments.Item(2)RestartDtc=WScript.Arguments.Item(3) ‘create global object Set objShell = WScript.CreateObject(“WScript.Shell”) ‘If Network DTC is enabled If EnableNetworkDTC = 1 Then     objShell.RegWrite “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\Security\NetworkDtcAccess”, 1, “REG_DWORD”…

4

How to implement Resource Manager in SYSTX?

Following links will help you to write resource manager by using SYSTX classes   http://msdn2.microsoft.com/en-us/library/ms229975(VS.80).aspx http://weblogs.asp.net/pgielens/archive/2005/02/19/376609.aspx http://blogs.msdn.com/florinlazar/archive/2005/05/17/418595.aspx http://pluralsight.com/blogs/jimjohn/archive/2006/01/24/18280.aspx http://pluralsight.com/blogs/jimjohn/archive/2006/01/21/18170.aspx http://www.developer.com/net/net/article.php/3565196

0

SAMPLE:How to use system.transaction to intiate transaction with oracle

//copy following program into console app and replace connection string and query string using System;using System.Collections.Generic;using System.Text;using System.Transactions;using System.Data;using System.Data.SqlClient;using System.Data.OleDb; namespace TransClient{    class Program    {              static void Main(string[] args)       {           ConnectToOracle();           Console.WriteLine(“Press any key to quit”);           Console.ReadKey();        }                //Try to connect to oracle database         public static void ConnectToOracle()        {                …

2

How to configure DTC to support oracle transactions

   (1)Make sure you have MDAC 2.6, sp2 higher and make sure you have oracle client (we have lot of problems with oracle 8i client,We recommend to use oracle client 9i or higher)     ((2)Make sure Network service account has read access to oracle client dlls.   http://support.microsoft.com/default.aspx?scid=kb;en-us;816633       (2)Enable Xa transactions…

1

MSDTC security model in windows 2003,sp1(same as windows xp,sp2)

//This content applies to windows 2003,sp1 and windows xp,sp2 machines Microsoft introduced MSDTC security in windows xp and windows 2003,If you didn’t configure MSDTC security settings properly,you may not able to run MSDTC transactions between two machines. like i explained in my previous blog (http://blogs.msdn.com/madhuponduru/archive/2005/12/03/499781.aspx), MSDTC is RPC application,so MSDTC security model also some what…

0

How to change System.Transactions timeout?

System.Transactions actually has two timeout values that can be specified in the configuration files. In app.config, there is a “timeout” setting.  If this setting is not specified, it defaults to 1 minute.  But it can be overridden in code in the constructor for CommittableTransaction or TransactionScope.   In machine.config, there is a “maximum timeout” setting. …

3

Transaction specifications(OLE/XA/TIP/WS-Coordination, WS-AtomicTransaction and WS-BusinessActivity)

The WS specifications related to Transactions (WS-Coordination, WS-AtomicTransaction and WS-BusinessActivity) http://msdn.microsoft.com/webservices/webservices/understanding/specs/default.aspx?pull=/library/en-us/dnglobspec/html/wsatspecindex.asp. XA transaction specification http://www.opengroup.org/onlinepubs/009680699/toc.pdf TIP transactions specification http://www.ietf.org/rfc/rfc2371.txt OLE Transactions Modelhttp://windowssdk.msdn.microsoft.com/library/en-us/Mts/rmguidetug_7pd8.asp?frame=true

0

MSDTC RPC COMMUNICATION

MSDTC is RPC application, so if you are running transaction between two machines, MSDTC will use RPC protocol to communicate with remote machine RPC is heart of all Microsoft Distributed application (not in web service world),MSDTC,COM,COM+ will use RPC protocol to communicate with remote machine. It is very easy to understand RPC basics, the way…

7

MSDTC BLOGS

I found these blogs are very useful to know about MSDTC(I just want save you some time,adding all the blog links here) http://blogs.msdn.com/florinlazar/http://pluralsight.com/blogs/jimjohn/default.aspx  http://blogs.msdn.com/esperpento/  http://blogs.msdn.com/miguel/ http://pluralsight.com/wiki/default.aspx/Don.TransactionAsks

0