Hi

I have an COM Dll which wraps ADO Functions It Does about this:

1- Creates ADO Objects, RS, connection, Command, parameters, etc...
2- Does my process (Query Delete Update, Etc...)
3- Set All ActiveConnection To NULL

When i look in Sql Server Profiler log, i can see a connect event then my Dll actions but no diconnect !!, it only disconnect when i release the object reference when my Dll Is Not IN MTS. When it is in MTS, it disconnects about one minute after it connects. Does anybody know if this behavior is normal ? If it is, it defeats the purpose of offline work and saving SQL Server licences.

Thanks.