Unable to begin a distributed transaction 64bit client to 32bit server
I am trying to update Oracle table from SQL Server via linked server but I get the error:
The
operation could not be performed because OLE DB provider
"OraOLEDB.Oracle" for linked server "TEST" was unable to
begin a distributed transaction
The connection between two servers is correct and works perfectly when I run select statements, but if only I try to run update or insert statement in transaction I get the above error.
machine A:
Oracle DB 9.2.0.6.0
Windows 2003 R2 with SP2 (32bit)
machine B:
SQL Server 2008R2 64bit
Windows 2008 R2 64bit
Oracle Client 11.2.0 64bit
MSDTC is configured on each machine with allow inbound and outbound options and enable XA transactions.
The connection between two servers is correct and works perfectly when I run select statements, but if only I try to run update or insert statement in transaction I get the above error.
machine A:
Oracle DB 9.2.0.6.0
Windows 2003 R2 with SP2 (32bit)
machine B:
SQL Server 2008R2 64bit
Windows 2008 R2 64bit
Oracle Client 11.2.0 64bit
MSDTC is configured on each machine with allow inbound and outbound options and enable XA transactions.
0