Software

Ask something
Discussion Locked

problem : starting distributed transaction on oracle from sql server

0 helpful
1 reply

by jaydeeps

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

Server: Msg 7391, 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].

1 reply

by parodrigues

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..."

This discussion is closed to new replies.