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

 

 

Reply via email to