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 !!!!