General information
Category:
COM/DCOM and OLE Automation
Title:
Disconnected RecordSet
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.
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