Informix Linked Server Distributed Transaction

[Eric Stott]

I can execute a stored procedure on the SQL instance that executes a few
commands against an informix database.
However, when I have BizTalk execute the same stored procedure from another
machine I get this error:
Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5740
Date: 8/8/2008
Time: 7:24:03 AM
User: N/A
Computer: BIZTALKDEV
Description:
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
Description="The operation could not be performed because OLE DB provider
"Ifxoledbc" for linked server "INFORMIX_TEST" was unable to begin a
distributed transaction."
".

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I have configured that DTC is enabled in the Add/Remove Programs, and
allowed inbound and outbound with no authentication transactions in the DTC
secuirty configuration.

Anyone experience this before?

Thanks,
Eric

[hans dampf]

hi There

I'm experiencing the same problem.
Did you find a solution?

best regards

Hans

[hans dampf]

Hi There!

I'm experiencing the same problem!

Did You find a solution?

Best regards

Hans

> On Friday, August 08, 2008 3:31 AM Eric Stott wrote: