When Trying to Use TransactionOption Set To Required Resulted In Error "Unable To Enlist In The Transaction"

(Doc ID 754248.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Services for Microsoft Transaction Server - Version: and later   [Release: 10.2 and later ]
z*OBSOLETE: Microsoft Windows Server 2003
z*OBSOLETE: Microsoft Windows 2000
z*OBSOLETE: Microsoft Windows XP
z*OBSOLETE: Microsoft Windows Server 2003 R2 (32-bit)
z*OBSOLETE: Microsoft Windows Vista (32-bit)
z*OBSOLETE: Microsoft Windows Server 2008 (32-bit)
Microsoft Windows 2000Microsoft Windows XPMicrosoft Windows Server 2003Microsoft Windows Vista (32-bit)Microsoft Windows Server 2003 R2 (32-bit)Microsoft Windows Server 2008 (32-bit)
Sql Server 2005
Sql Server Buisness Intelligence Development Studio 2005


***Checked for relevance on 20-Jun-2011***

-- Problem Statement:
Oracle Services for MTS version
Oracle Client version
Oracle Database version

Attempting to use the Oracle Provider for OLEDB with the TransactionOption set to Required results in the error:

Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.".
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8004D00A.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms