DEVELOPERS FORUM - Insert Statement from Aras Innovator using Linked Server

mendenaresh1357 - Tuesday, November 30, 2010 4:52 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.

Brian - Tuesday, November 30, 2010 5:41 AM:

Hi Naresh,

I'm afraid this is a little out of my area but I would start with this link:

http://support.microsoft.com/kb/306212

or this one:

http://support.microsoft.com/kb/329332

Cheers,

Brian.

mendenaresh1357 - Tuesday, November 30, 2010 5:59 AM:

Hi Brian,

  Thanks for the quick reply. But the issue is not with MSDTC settings or linked server setting. Since the insert query executes fine from SQL Server management Studio. But when i execute the same query from within Aras, then i find the issue.

Regards,

Naresh