ORAMTS Problem 0x8004d00a - Help appreciated - SOLVED
Hi yall..
This is my problem.
I installed 10G database and client and 11i ODAC in a windows 2003 server box with SQL Server 2000 SP4, in order to create a linked server to a 9i production server in our company
I was able to create the linked server via Oracle Provider for OLE DB, and could run a simple select and insert query from Query Analyzer
The problem is that when I place the insert inside a transaction block (BEGIN TRAN / COMMIT) I get this error:
The operation could not be performed because the OLE DB provider 'OraOLEDB.Oracle' was unable to begin a distributed transaction.
This is my problem.
I installed 10G database and client and 11i ODAC in a windows 2003 server box with SQL Server 2000 SP4, in order to create a linked server to a 9i production server in our company
I was able to create the linked server via Oracle Provider for OLE DB, and could run a simple select and insert query from Query Analyzer
The problem is that when I place the insert inside a transaction block (BEGIN TRAN / COMMIT) I get this error:
The operation could not be performed because the OLE DB provider 'OraOLEDB.Oracle' was unable to begin a distributed transaction.
0