I created a Trigger that fetches data from a SQL Server table and writes or updates data from another table in Oracle if there is a change. All this via LinkedServer. But running it generates the following error:
The OLE DB provider "OraOLEDB.Oracle" for the linked server "INTERFTRIMERP" returned the message "New transaction can not enlist in the specified transaction coordinator."
Msg 7391, Level 16, State 2, Procedure InserPedidoQtdProgChange, Line 39
The operation could not be performed because the OLE DB provider "OraOLEDB.Oracle" for the linked server "INTERFTRIMERP" could not initiate a distributed transaction.
What could be happening?
With tables only SQL Server works normally, now via linked server to Oracle, it generates this error.