Problem with SQL adapter

Hi!

There’s an Oracle, and a Postrgre SQL database, which we connect to the local SQL server as linked servers (with ODBC).
We have two stored procedures to query some tables from these databases.

From Biztalk, we call these stored procedures (with SQL adapter). Usually the orchestrations work fine, but after some time, there comes an error. In the event log, we find these messages:

[quote:e2a256a7cd]Event id :5743

The adapter failed to transmit message going to send port \”VIPCC_ETISSQLPort\” with URL \”SQL://ISBUDAAPL01/DB_VIPCC/\”. It will be retransmitted after the retry interval specified for this Send Port. Details:\”HRESULT=\”0x80040e14\” Description=\”The operation could not be performed because the OLE DB provider ‘MSDASQL’ was unable to begin a distributed transaction.\”
HRESULT=\”0x80040e14\” Description=\”OLE DB error trace [OLE/DB Provider ‘MSDASQL’ ITransactionJoin::JoinTransaction returned 0x8004d00a].\”
HRESULT=\”0x80040e14\” Description=\”[OLE/DB provider returned message: Unsupported connect attribute (Set)]\”\”.[/quote:e2a256a7cd]

[quote:e2a256a7cd]Event id:5740

The adapter \”SQL\” raised an error message. Details \”HRESULT=\”0x80040e14\” Description=\”The operation could not be performed because the OLE DB provider ‘MSDASQL’ was unable to begin a distributed transaction.\”
HRESULT=\”0x80040e14\” Description=\”OLE DB error trace [OLE/DB Provider ‘MSDASQL’ ITransactionJoin::JoinTransaction returned 0x8004d00a].\”
HRESULT=\”0x80040e14\” Description=\”[OLE/DB provider returned message: Unsupported connect attribute (Set)]\”[/quote:e2a256a7cd]

These errors appear under BizTalk 2004 and 2006 also.

When we delete the stored procedure and create it again, then the orchestration continues to run without error.

We don’t know why this error appears, and it’s very random, when appears it. After an hour, after a day, sometimes after a week…
(We run the query in every 5 minutes.)

Does anyone have an idea how we can we solve this problem?