Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'MSDAORA' was unable to begin a distributed transaction - why?! (SQL <-> Oracle)
I probably have permission to delete the Oracle records, but I don't
actually perform the delete operations, hence no need for Oracle
transactions as I don't change anything on the Oracle side.
But from technical point of view, I can understand it everything gets
pushed through transactions, I was thinking maybe I could tell the SQL
Server not to tunnel the Oracle queries through such transactions.
I'll try to check the version and publisher of the Oracle driver
backing the linked server.
Received on Fri May 12 2006 - 16:12:13 CDT