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

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

"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

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

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

"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 ?

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

"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

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

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