distributed query not working in sqlserver 2012

• mubashir.hashmi

  Old Hand

  Points: 361

  More actions

  March 2, 2016 at 7:18 am

  #308956

  I use Distributed queries and updating record in the DB2 database using sql server through addlinkedserver , it working fine when scope of the transaction not use in the query, can any one solve how to use distributed query

  BEGIN TRANSACTION;

  update [linkedservername].[database].[schema].[tablename]

  set DT_OF_BIRTH='1947-04-10',TEL_OFFICE='3353322'

  COMMIT TRANSACTION;

  Error Msg 7390

  The requested operation could not be performed because OLE DB provider "DB2OLEDB" for linked server "linkedservername" does not support the required transaction interface.

  Regards

  Mubashir

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  March 3, 2016 at 11:56 am

  #1862881

  is this helpful?

  http://stackoverflow.com/questions/12786654/does-not-support-the-required-transaction-interface