SUPPORT Q&A - Insert Statement from Aras Innovator using Linked Server

mendenaresh1357 - Tuesday, November 30, 2010 4:51 AM:

Hi All,

      I have a SQL (insert) Statement which works fine from the SQL Server Management Studio. But the same statement when i execute from "Aras Innovator" using applySQL API, I get the error "OLEDB provider Failed to begin a distributed transaction". I have well configured the driver using for Linked Server and the MSDTC settings.

The insert statement is given below.

Insert into LINKEDSERVER.DATABASE.SCHEMA.TABLE (col1,col2, col3) values( '306', '11073', 'ADD').

I feel like am missing some Aras Client Configurations, since the same query works fine from SQL Server Management Studio.

The error Screen is attached below:

Any help will be appreciated.

Thanks & Regards,

Naresh Mende.