Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 10 total |
get list of users of a database |
Thu, Oct 4 2007 5:54 PM | Permanent Link |
"Iztok Lajovic" | Tim,
I cannot find a way (after reading manual first) to detect in C/S environment if there are any active users (sessions) of a particular database. I want to be sure that there is nobody using a database before I start the backup procedure. Thanks Iztok Lajovic |
Mon, Oct 8 2007 11:31 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Iztok,
<< I cannot find a way (after reading manual first) to detect in C/S environment if there are any active users (sessions) of a particular database. I want to be sure that there is nobody using a database before I start the backup procedure. >> Unfortunately there is no way to do so. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Oct 8 2007 2:36 PM | Permanent Link |
"Robert" | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:EBC623C9-D490-4E8B-BC2F-3565E1D54693@news.elevatesoft.com... > Iztok, > > << I cannot find a way (after reading manual first) to detect in C/S > environment if there are any active users (sessions) of a particular > database. I want to be sure that there is nobody using a database before I > start the backup procedure. >> > > Unfortunately there is no way to do so. > If there is a table that everybody has to have open, try to open it exclusive. Or (much better, IMO) you can add semaphores as users log in, then release them as users log out, and test for no sempahores active (except your own, of course) before you start the backup. You can also use a special semaphore to tell other users that you are doing a backup and they have to wait before logging in. Robert |
Tue, Oct 9 2007 2:31 AM | Permanent Link |
"Iztok Lajovic" | Tim,
> > << I cannot find a way (after reading manual first) to detect in C/S > environment if there are any active users (sessions) of a particular > database. I want to be sure that there is nobody using a database before I > start the backup procedure. >> > > Unfortunately there is no way to do so. > Will ElevateDB have this possibility? Iztok Lajovic |
Tue, Oct 9 2007 2:35 AM | Permanent Link |
"Iztok Lajovic" | Robert,
> > If there is a table that everybody has to have open, try to open it > exclusive. Or (much better, IMO) you can add semaphores as users log in, > then release them as users log out, and test for no sempahores active > (except your own, of course) before you start the backup. You can also use > a special semaphore to tell other users that you are doing a backup and > they have to wait before logging in. > Thank you. I wanted to make things on a system level so that I have all my applications just compile and build, otherwise I have to implement this exclusive table test in each of them. Iztok Lajovic |
Tue, Oct 9 2007 4:46 AM | Permanent Link |
"Frans van Daalen" | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:EBC623C9-D490-4E8B-BC2F-3565E1D54693@news.elevatesoft.com... > Iztok, > > << I cannot find a way (after reading manual first) to detect in C/S > environment if there are any active users (sessions) of a particular > database. I want to be sure that there is nobody using a database before I > start the backup procedure. >> > > Unfortunately there is no way to do so. > Maybe I misread this but by using GetRemoteSessionCount you can count the active sessions in a c/s ? |
Tue, Oct 9 2007 5:50 AM | Permanent Link |
"Iztok Lajovic" | Frans,
> > Maybe I misread this but by using GetRemoteSessionCount you can count the > active sessions in a c/s ? Yes, I can, but our applications have many nested forms and each form opens its own session. Session count therefore doesn't mean number of users. Thank you Iztok Lajovic |
Tue, Oct 9 2007 7:56 AM | Permanent Link |
"Frans van Daalen" | "Iztok Lajovic" <iztok.lajovic@amis.net> wrote in message news:DC8D71D0-58AE-4FA4-BE16-EF106DD4BF1D@news.elevatesoft.com... > Frans, > >> >> Maybe I misread this but by using GetRemoteSessionCount you can count the >> active sessions in a c/s ? > Yes, I can, but our applications have many nested forms and each form > opens its own session. Session count therefore doesn't mean number of > users. > But the amount is not off any interrest because you only wanted to know if anyone was connect to make sure you could do a backup |
Wed, Oct 10 2007 8:25 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Iztok,
<< Will ElevateDB have this possibility? >> Possibly, but currently you can only get a list of sessions just like with DBISAM. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Oct 10 2007 8:26 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Frans,
<< But the amount is not off any interrest because you only wanted to know if anyone was connect to make sure you could do a backup >> Yes, but he wants to know which connections are using a particular database, not just the active connections in general. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, April 26, 2024 at 06:09 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |