Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to detect ODBC sessions holding tables?
Message
 
 
To
02/11/2009 15:53:17
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Web
Miscellaneous
Thread ID:
01432772
Message ID:
01432785
Views:
31
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform