General discussion

Locked

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.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

So...

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

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums