General discussion


problem : starting distributed transaction on oracle from sql server

By jaydeeps ·
begin distributed transaction
insert into openrowset('MSDAORA','SMPTEST';'scott';'tiger','select * from dept') select '56','OFFICER','DELHI' From owner
commit transaction

Server: Msg 73**, Level 16, State 1, Line 3
The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -


by parodrigues In reply to problem : starting distri ...

I have the same problem. Very strange. I need update a oracle table with registers of the msde table. I made a msde stored procedure that update oracle table and it?s working, but when i call this sp from trigger I read "...MSDAORA was unable to begin..."

Related Discussions

Related Forums