Patti,
Are these local area network session or Terminal User sessions.? In either
case here are your options
Local Area Connected shares stuck open - On the Server with the Database Shares
* Open Computer Management. (right click on My computer and Click Manage)
* In the console tree, click Sessions.
To disconnect all users, on the Action menu, click Disconnect All Sessions.
To disconnect one user, in the details pane, right-click the user name, and
then click Close Session.
To disconnect multiple users, press the CTRL key while clicking the user names,
right-click any user name, and then click Close Session.
You can also do this at the command prompt, or create a batch file to do this
automatically each night from the command line but you need to do this for each
computer in your network, which is easy for a small office, but not recommended
for a large office
* Open Command Prompt.
* net session\\computername/delete
If this is a Remote Desktop Connection that is stuck then
Open the Terminal Services Manager under Administrative Tools
Find the Session that is stuck, right click on it and click
Disconnect, then right click again and click reset.
You can also do this from the command prompt, after first finding the Session
ID that is stuck
On the Terminal Server, click Start, and then click Run.
Type cmd, and then click OK.
Determine the name or ID of the session that you want to disconnect. To do so
type query session
Once you find the Session ID type tsdiscon SessionID
Keep in mind you are forcibly closing open RBase sessions, Not always
recommended.
Frank Taylor - Information Technology Administrator
F.J. O'Hara & Sons, Inc - Araho Transfer Inc.
Boston, MA - Rockland, ME - Miami, FL
Direct Dial - 617-790-3093
email:
[email protected]<http://mail.whitewolftechnologies.com/cgi-bin/compose.exe?id=01ef7f9322f8a76400dacb6a1fe342bb5a7&new=&xsl=compose.xsl&[email protected]>
From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz
Sent: Thursday, June 23, 2011 10:39 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - disconnecting old database connections
Hi,
We have two users that use windows remote workstation to connect to our
database. When these users end their session, the exit the application and
logout. But Rbase thinks they are still connected. I noticed that if I click
on the "disconnect" menu option, Rbase will show one less user connected. So I
know how to fix this problem from now on.
But how do I disconnect all these connections that are no longer even ther?.
Legacy versions of Rbase had some way to force disconnections. I need to pack
the database, since I added a column to a table that has 650,000 rows.
(We also have a system administrator who comes in two half days per month and
we're a week away from his next work day.)
Thanks,
Patti
