Hi Razzak, This almost worked, but I couldn't copy the local files back to the server. It thinks they're open somewhere, even though they're not. I'm gonna try the commands sent by Karen, Bill & Frank to unattach the user connections from the server. Now I just have to find the server. It's always something.... Thanks for your help. 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, 4:48 PM At 12:19 PM 6/23/2011, Patti Jakusz wrote: > 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. Patti, If you know for sure that there are no active users, you may try the following technique to reset the connection count. Follow these steps: 01. Copy all four files (.rb1 - .rb4)) in a temporary folder on your local workstation. 02. Start R:BASE 7.6 (I know ...) 03. At the R> Prompt: SET MULTI OFF 04. Now CONNect the database you just copied on your local workstation. 05. DISCONNECT the database 06. At the R> Prompt: SET MULTI ON 07. Now CONNect the same database again 08. Look at the "Connections" Database Explorer | Main Menu | Tools | Connections ... OR SET VAR v1 = (CVAL('CONNECTIONS')) SHOW VAR v1 Notice the number of connected users. If you have followed all steps correctly, there should be only 1 connection; that's you! 09. DISCONNECT 10. Now copy all these four (.rb1-.rb4) files back to your network server and you should be all set. Have fun! Very Best R:egards, Razzak.
