>I posted these 2 questions a couple weeks ago and still no answer, anybody ?? Actually i figured out (i think) the second question but the first remains an unsolved mistery.
>
>1rst Question
>-------------
>In COM+, All my properties of a Com DLL Are showing twice, is this normal ? how can i fix it? (Using W2K Server SP1, VFP 6 SP4)
>
>
>2nd Question
>------------
>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 And Close() the connection
>
>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.
Can setting CommandTimeOut or ConnectionTimeOut to a near 0 (at session end) force the release?
Imagination is more important than knowledge