Using distributed transactions using OraOLEDB.Oracle

Connection string

This Oracle Provider for OLE DB connection string can be used for connections to Oracle.

This one specifies sessions to enlist in distributed transactions. This is the default behaviour.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Password=myPassword;DistribTX=1;

Valid values are 0 (disabled) and 1 (enabled).