Hi Mike, I'm going to add that logic for to stop this from happening, but I have to get rid of those old connections that are hanging out there. Hopefully, resetting the server. Thanks, Patti
--- On Thu, 6/23/11, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: [RBASE-L] - Re: disconnecting old database connections To: "RBASE-L Mailing List" <[email protected]> Date: Thursday, June 23, 2011, 3:52 PM Patti: Are you using the TIMEOUT setting? This might accomplish your purpose. Per the comments in R:BASE Help: "Use TIMEOUT to shut down an inactive R:BASE workstation and exit to Windows after a set amount of time passes. A countdown only begins when R:BASE is waiting for a keystroke--not while R:BASE is processing commands or while you are entering data. This is a useful feature for automatically disconnecting idle R:BASE sessions for scheduled database maintenance. " If you add something like SET TIMEOUT 60 command to a user's startup file it will cause R:BASE to exit after 60 minutes if there is no KEYBOARD activity. Maybe that will help. Mike Ramsour From: Patti Jakusz <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: 06/23/2011 11:38 AM Subject: [RBASE-L] - Re: disconnecting old database connections Sent by: [email protected] I would love to buy the RBADMIN product but I would have to spring for it out of my own pocket right now. Would resetting the server help in this instance? Thanks. Patti --- On Thu, 6/23/11, A. Razzak Memon <[email protected]> wrote: From: A. Razzak Memon <[email protected]> Subject: [RBASE-L] - Re: disconnecting old database connections To: "RBASE-L Mailing List" <[email protected]> Date: Thursday, June 23, 2011, 2:43 PM At 10:38 AM 6/23/2011, Patti Jakusz wrote: > 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 Patti, Take a look at the R:BASE Database Administrator: http://www.rbaseadmin.com/ RBAdmin is available for R:BASE 7.6, Turbo V-8, and R:BASE eXtreme 9.1 (32/64). Very Best R:egards, Razzak. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
