Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Disconnecting and reconnecting clients
Fri, Jul 28 2006 8:26 AMPermanent Link

MiA
Which is the best way to disconnect the clients from the database for a
while to have the full access to all service operations (for instance
optimization) and then to give them the possibility to reconnect? Is it
possible to do with my own custom service program accessing the database
directly on the server machine?

Thank you,
MiA
Fri, Jul 28 2006 10:06 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Which is the best way to disconnect the clients from the database for a
while to have the full access to all service operations (for instance
optimization) and then to give them the possibility to reconnect? Is it
possible to do with my own custom service program accessing the database
directly on the server machine? >>

Just stop the server (don't close down the server process, just stop it from
listening for new connections).  That will disconnect all client
connections, but the sessions will still stick around so they can be
reconnected when you're done and the client applications can resume their
work.  This requires that your dead session expiration time on the database
server be set high enough that the database server doesn't remove any of
these sessions while this is going on, however.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Jul 29 2006 5:07 AMPermanent Link

"Janusz Cyran"
Tim,

After stopping the server and trying OptimizeTable I've got the message:
"DBISAM Engine error # 11013 Access denied to table or backup file
'BIEZACY'", where BIEZACY is my table.

Janusz Cyran




Użytkownik "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> napisał
w wiadomo¶ci
news:60D39494-0DA2-4F03-922A-26C35DE5A894@news.elevatesoft.com...
>
> << Which is the best way to disconnect the clients from the database for a
> while to have the full access to all service operations (for instance
> optimization) and then to give them the possibility to reconnect? Is it
> possible to do with my own custom service program accessing the database
> directly on the server machine? >>
>
> Just stop the server (don't close down the server process, just stop it
> from listening for new connections).  That will disconnect all client
> connections, but the sessions will still stick around so they can be
> reconnected when you're done and the client applications can resume their
> work.  This requires that your dead session expiration time on the
> database server be set high enough that the database server doesn't remove
> any of these sessions while this is going on, however.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Sun, Jul 30 2006 1:29 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Janusz,

<< After stopping the server and trying OptimizeTable I've got the message:
"DBISAM Engine error # 11013 Access denied to table or backup file
'BIEZACY'", where BIEZACY is my table. >>

My apologies, I missed that you said you were going to try to optimize the a
table or tables.  Anything that requires exclusive access is going to
require you to kick the users completely out of the server by removing the
server sessions that still have these tables open.  That's the only way that
you can free up the tables so that you can get exclusive access to them when
you run OptimizeTable on them.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jul 31 2006 9:43 AMPermanent Link

MiA
Tim,

It works, thank you. But what to do to reconnect the clients after the
work is done? Is it necessary to close the client program and start it
again? Can it be done other way?

Janusz Cyran


> Janusz,
>
> << After stopping the server and trying OptimizeTable I've got the message:
> "DBISAM Engine error # 11013 Access denied to table or backup file
> 'BIEZACY'", where BIEZACY is my table. >>
>
> My apologies, I missed that you said you were going to try to optimize the a
> table or tables.  Anything that requires exclusive access is going to
> require you to kick the users completely out of the server by removing the
> server sessions that still have these tables open.  That's the only way that
> you can free up the tables so that you can get exclusive access to them when
> you run OptimizeTable on them.
>
Tue, Aug 1 2006 8:53 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Janusz,

<< It works, thank you. But what to do to reconnect the clients after the
work is done? Is it necessary to close the client program and start it
again? Can it be done other way? >>

You'll need to, at the very least, close down the TDBISAMSession in the
client application, and then re-open it.   It would help to implement the
TDBISAMSession.OnRemoteReconnect event handler in order to prevent any error
messages about reconnects to pop up while you are doing this:

http://www.elevatesoft.com/dbisam4d5_tdbisamsession_onremotereconnect.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Image