-
I am wanted to update data using triggers from sql server to oracle using linked servers. I am getting the following error
"[MICROSOFT] [PODBC SQL SERVER DRIVER][SQL SERVER] THE OPERATION COULD NOT BE PERFORMED BECAUSE THE OLE DB PROVIDER 'MSDAORA' DOES NOT SUPPORT DISTRIBUTED TRANSACTIONS"
What is the parameter that I should set for this to work.
Any help !!!!
-
it seems that you have a problem with the odbc driver , also beadvised that in SQL Server 7 triggers are after only not like Oracle after and before
