Distributed transaction error only through code

Question

I will try to execute the query on the linked server (SQL Server 2008 associated with Sybase) and select it in the temp table. Works fine, although the query window is in SQL Management Studio, but when I do this using code (C #), it fails with the error "The operation could not be completed because the OLE DB provider" ASEOLEDB "for the linked server" MYLINKEDSERVER " Could not start the distributed transaction. I do not use the transaction in the code with my DbConnection.

This query is as follows:

SELECT * INTO #temptable FROM OPENQUERY([MYLINKEDSERVER], 'SELECT * from table') 

Answer 1

Problem detected. This was the result of combining compounds. It seems that the connections are being reused, causing the system to think that a distributed transaction is occurring.