Before you close the ADO session, assure the "State" is 1. You can review the COM in "ADO Query Analyzer" for specifics in the download section.
>I've been running some further tests and it seems that the connection "disappears" from performance monitor after around one minute. Furthermore, if I create a connection, open it, and then call it's close method, it also keeps showing up in performance monitor, but if I call close again there's an error indicating me that the connection is already closed, which of course figures. Maybe it's just a form of connection "pooling", can anyone confirm or deny this?
>
>>Using VFP 6, SP5, SQL Server 7.0 Developer edition and MDAC 2.7 (ADO), I'm running into this situation with code like the following :
>>
>>
>>thisform.oConnection.Open()
>>thisform.RunProcess()
>>thisform.oConnection.Close()
>>MessageBox("Process finished")
>>
>>
>>The connection remains open until I close the messagebox window.
>>
Imagination is more important than knowledge