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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only