General discussion
May 19, 2005 at 06:28 AM
jaydeeps

problem : starting distributed transaction on oracle from sql server

by jaydeeps . Updated 21 years, 3 months ago

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

This discussion is locked

All Comments