> when your application(s)

There now lies the problem. It is not my application and I have no control
over it.
We probably will be moving to 2.x (again not
my decision) in the next year or so, but untill
then I need to find another solution.

RBS

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