Unable to begin a distributed transaction

• Sanjay Masawan

  Ten Centuries

  Points: 1031

  More actions

  April 25, 2006 at 5:08 am

  #91264

  Hi gurus

  I have a link server created for Oracle using ORacle ODBC driver

  It works fine with SELECT's and plain insert and updates

  BUT if BEGIN TRANSACTION and COMMIT is sued it gives the below error.

  Please help

  The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.

  OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].

• April 28, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 28, 2006 at 8:14 am

  #634863

  It cannot execute those items on the Oracle driver.