Getting Error When Inserting Data in Linked DB2 server from a Linked Server
I created a update trigger on a sql table in my sql server to insert records in a linked server DB2 table. Insert Query works fines when I run it separately. However it doesn't work when I run it in the trigger.
However I get an error below
'The operation could not be performed because OLE DB provider "IBMDASQL" for linked server "AS400" was unable to begin a distributed transaction.'
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.