Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 6 of 6 total |
Disconnecting and reconnecting clients |
Fri, Jul 28 2006 8:26 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |