>>>Hi Naomi:
>>>
>>>Thanks for your answer . The thread deals with network connections only. However, there are neither open sessions nor any opened files from any remote machines
>>>
>>>I assume that ODBC is an internal process opening files locally that are not being closed after being queried.
>>>
>>>I wonder if there is a tool to view such internal connections
>>>
>>>
>>In SQL Server you can view open connections using sp_who or sp_who2 stored procedures. I'm not sure about ODBC tool - I'll ask around quickly.
>
>I tried making some research, but didn't get any answers and my own google searches were not successful.
>
>
http://bytes.com/topic/asp-classic/answers/127196-how-can-i-list-all-open-connectionsThanks Naomi:
I'll check the link an post the solution when found.
Regards