Linked Server to Oracle

Question

i am trying to write one trigger on sql server table which will insert a record on oracle table . it was working fine but all of a sudden i am getting a error message as "The Operation could not be performed because OLEDB Provider OraOLEDB.Oracle' for linked server 'IFST' was unable to begin distributed transaction.OLE DB provider OraOLEDB.Oracle for linked Server 'IFST' returned message "Unable to enlist in the transaction"

Answer 1

Hi Arif_dxb,

The purpose of this forum is to support the Open Specifications documentation. You can read about the Microsoft Open Specifications program at https://msdn.microsoft.com/en-us/openspecifications/default. The library of Open Specification documents is located at https://msdn.microsoft.com/library/dd208104.aspx.

 

It doesn’t appear that you are implementing one of the protocols cited. if you are working with a specific on-the-wire Windows protocol please provide additional information regarding which protocol so that we can better understand how we can assist you.

We suggest posting your question to the following forum, with an appropriate tag:

https://docs.microsoft.com/en-us/answers/products/sql-server

Best regards,

---

Jeff McCashland | Microsoft Protocols Open Specifications Team