Dear Friends,

We have application in d5->ibo->fb_1.5.2 with
database on Linux Server and w9x/xp clients.

Many times some clients get terminated in improper
way i.e. either ctrl-alt-del in case of long process
and user is in hurry or power failures.

At Day end application is checking no of connections
to database through IBO database comp's User count
property and if no of users is 1 then day end process
can proceed. But since improper disconnected connections
still active and user count is greater than actually
connected connections hence even though all currently
connected nodes are exited user count is always more
than 1. Usually we do firebird restart to solve this
problem but now we have added another application
which uses another database and we have to tell users
of that application to disconnect and then we can
do firebird restart.

Can somebody tell me how to clear such connections for a database only
or any other setting where firebird will check for connectivity
of a node for parameterized no of minutes and close that
connection automatically

Thanks and Best regards

R. S. Patil