Jim,

Another way to fix the "stuck" user issue is to go to the server where the DB 
is shared (make sure all users are out so you are not closing an active 
connection by mistake), Right click on MY Computer, click on Manage, expand the 
shared folders item and then click on open files.  Look for any connections in 
there to the DB, right click on the open file to the DB and click on close 
file.  Do this for any file in that list until there are no more.  That should 
clear up and stuck users and allow you to connect to the DB with Multi off.  Of 
course another way to clear them is to restart the server, but only as a last 
option would I do that.

-- Frank


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]<mailto:[email protected]>


From: [email protected] [mailto:[email protected]] On Behalf Of Paul 
InterlockInfo
Sent: Tuesday, May 26, 2009 11:44 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Idea:  'set var vtConnections TEXT = (CVAL('CONNECTIONS'))'  and then you know 
or see how many connections are out there first.

Sincerely,
Paul Dewey





From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove
Sent: Tuesday, May 26, 2009 11:30 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Jim,

As has been noted, you probably have orphaned sessions around.

What has worked for me in the past is to SET MULTI ON, CONNECT to the database, 
DISCONNECT, SET MULTI OFF then CONNECT.

If that fails, you may need to reboot the server.

Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]

From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Monday, May 25, 2009 6:12 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Adrian,

Once I turn rbadmin on, what is the nextstep?

Jim


________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Adrian Hüssy
Sent: Monday, May 25, 2009 5:07 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Jim
OK, in this case you have definitely a connection to this database.
If you often have this problem, RBAdmin would allow you to display and cancel 
open connections.

I had a similar problem last year with VPN-connections and RDP-sessions which 
broke down every now and then.
But at this special case, R:Base displayed every connection, also broken ones.

Good luck

Adrian

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Monday, May 25, 2009 11:53 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Adrian,

I am not able to rename the database so even though I show no connections, 
there has to be a connection somewhere.  I will have to wait until Tuesday to 
investigate further.  Thanks for the suggestions.

Jim

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Monday, May 25, 2009 4:47 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

I will back them up and try.

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Adrian Hüssy
Sent: Monday, May 25, 2009 4:45 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Are you able to rename the database files now. You could even rename it back 
after testing.

Adrian

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Monday, May 25, 2009 11:37 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

I appreciate you looking at the previous emails.  I also thought that might be 
the problem when this first started so I made sure I was disconnected from the 
other DB and also detached the tables.  That did not change anything.

jim

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Adrian Hüssy
Sent: Monday, May 25, 2009 4:35 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Jim
I found a mail from you some days before. You used SCONNECT and SDETACH to 
attach other databases.
Could it be your database is still connected by an ODBC connection and you have 
trouble to pack them that's why?
I would check this point too.

Adrian

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Monday, May 25, 2009 10:35 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Adrian,

Yes I was disconnected when I attempted to set multi off.  It turned off but 
would not allow me to connect.  When I set it back on, it allowed me to connect 
then I checked the connections and it shows only one connection.  No one else 
is working.  If someone shut down without getting out of RBASE properly, would 
it create this problem?

jim

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Adrian Hüssy
Sent: Monday, May 25, 2009 3:33 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: cannot pack

Jim,
To set MULTi OFF you have to be disconnected.
If you are able to connect in MULTI OFF, you are the only one and could do what 
ever you want.
If you aren't able to connect in MULTI OFF, there must be an other user 
connected or you are by yourself connected in an other session.


Best Regards

Adrian

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Monday, May 25, 2009 10:22 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - cannot pack

We have many users here at our company so the default setting is MULTI ON.  I 
need to do Maintenance on the DB (Pack) but when I set the MULTI to OFF it will 
not allow me to connect.  It states "The database is connected in a mode that 
makes it unavailable to you" (meaning me). I am the only one on since I go to 
the TOOLS | CONNECTIONS and it shows only one connection (when I am connected).

What would cause this?

Jim



_______________________________________________________________________
This Email has been scanned for all viruses by PAETEC Email Scanning Services, 
utilizing MessageLabs proprietary SkyScan infrastructure. If you need 
assistance, please contact the Systems Administrator, Frank Taylor at 
[email protected] - 617-790-3093.
** REMEMBER NEVER OPEN AN ATTACHMENT UNLESS YOU ARE SURE OF IT'S CONTENT AND 
SENDER **
_______________________________________________________________________

Reply via email to