--- In firebird-support@yahoogroups.com, bartsmissaert@... wrote:

>
> > So do you understand that a Classic
> > client process sees only the user that
> > is involved with *its* connection to the server?
>
> Yes, thanks, I do now.
> Pity that this information is not simply just held
> in the database.

Firstly, it is your choice to use an older version of Firebird without
monitoring tables. In 2.1, you can query MON$ATTACHMENTS for this
information.

Secondly, it is not brain surgery to just hold the information in the
database yourself within 1.5, Add a record when your application(s)
connect, delete it when they disconnect and create a secondary thread
to update a heartbeat timestamp so that is someone exits your
application in a hard manner (end task / cut power to client), that
connection can be disregarded after a reasonable time.

Adam