DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Linked server between sql server and oracle

171564Jun 20 2005 — edited Aug 19 2008

I have set up a linked server between sql 2000 and oracle9i database using MSDAORA. I have installed oracle9i client on sql box and modified the registry keys. Linked server works fine for selecting data from oracle database and I can insert a row into oracle table directly into oracle table from SQL query analyzer. I created a trigger on sql table so that when new data is inserted into this table, trigger should fire up and this new data should be inserted into oracle side. this is where it fails and give following error:
Server: Msg 7391, Level 16, State 1, Procedure tr_banister, Line 16
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].

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2008

Added on Jun 20 2005

#oracle-provider-for-ole-db, #windows-and-net

8 comments

23,380 views