I will very thankful if anyone could help me in the following problem?
I have a COM object, which is to be connected to some database and do something with the data.
It works with MS SQL, OLE DB and ADO and I want it to work at MTS with ‘requires a transaction’ mode.

The code of the method is as follows:

oMTX=CreateObject("MTXAS.APPSERVER.1")
oContext=oMTX.GetObjectContext()

dbconnection=CREATEOBJECT("ADODB.Connection")
WITH dbconnection.
.ConnectionString=”Provider=SQLOLEDB.1……….. and so on”
.Open
ENDWITH
……………..

oContext.SetComplete()

Everything is all right while I am using it without MTS ‘requires a transaction’.
But working in this mode gives much retardation.
Besiades, I don’t see disconnection in Profiler of MS SQL when MTS deactivates this object.
Can anyone say what I do wrong?