>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.
If it's not broken, fix it until it is.
My Blog