Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to detect ODBC sessions holding tables?
Message
From
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:
01432781
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


>>How to detect open ODBC open sessions
>>
>>Hi all:
>>
>>
>>A VFP Database is accessed through ODBC in order to display some data by an Internet browser.
>>
>>I need to run a maintenance application and open some tables in exclusive mode, but I’m not allowed.I'm guessing that some connections may still be active.
>>
>>¿How can I detect any ODBC connections and close them?
>>
>>Thanks in advance for any help.
>>
>>Regards
>
>Not sure, if this may help, but check How to view lock status Thread #1427317
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform