ADO objects take a long time to be destroyed
3-UsesTransaction.
In these classes I use a Recordset object to get some data and return them to the caller and call GetObjectContext.SetComplete|SetAbort if all went well|Not well.
I have another COM (B) that has in it one class (z) which has a transaction mode set to
2-RequiresTransaction.
The class B.z uses the services of A.x, and A.y to implement a business logic.
I am creating a COM+ application and inserting these three classes in it.
Now in my form (exe app) I am creating an instance of B.z using CreateObject("B.z"). In B.z's Methods I am also creating Instances of A.x, and A.y using CreateObject("...") syntax to use their services.
All is going well, until I reach a statement like
Set Rs = Nothing or
Set Cn = Nothing
In the methods of class x, and y
Where Rs is a recordset object and Cn is a connection object. These two statement are taking approximately half a minute to execute and after that returning to execute the next statement.
Please can you help me with my problem.
Am I missing something or going wrong someplace? I will appritiate your help greatly.
Blue-Squid.

