I had in mind to post a job to Rent A Coder to get something that will do
this, but if anybody on this forum is interested (for a fee) then let me
know. I need the connected users, that is users who are connected to a FB
Classic 1.5 database.
I need to run this from VB/VBA and I don't need any GUI, so the data can
be passed as a string, an array, a text file or written to a database
table.

RBS

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