I'm trying to create an insert trigger on a table in SQL Server to insert a corresponding record in an Oracle database.<br><br>I'm using SQL Server V7 and Oracle v805.<br><br>I can get the insert to work directly, but when it's put in the trigger I get 'Msg 7391 - OLE DB provider MSDAORA does not support distributed transactions'. <br><br>Does anyone know how to get around this?<br><br>Thanks<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trouble inserting data into Oracle from SQL Server
- Thread starter Dobbin
- Start date
Similar threads
- Locked
- Question
