> And, with Classic, you will get one user back - being the one that is

running the process from which the request was made



Yes, we are on Classic and that is exactly what I see.

Will ask in the ODBC group then.



RBS



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: 07 October 2008 04:41
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Get connected users



At 09:01 7/10/2008, you wrote:

>
>
>Using FB 1.5 and looking for a way to get the users that are connected to a
>particular database.

No. Superserver can deliver a list of users connected to the *server*.

>I know that this is a question that comes up often, but I haven't seen a
>simple solution yet.
>
>When we were on Interbase I used the free .exe file written by Karsten
>Strobel, IB_SHOWUSERS.exe
>
>Run via a .bat file to text:
>
>
>
>@ECHO OFF
>
>"C:\IB_SHOWUSERS.exe" -U xxx -P zzz FullDBPath > TextFile
>
>CLS
>
>EXIT
>
>
>
>And that works fine, but I don't think it can work with FB.

Should work with Fb 1.5 SS. Unless it has been updated to use the Services
API, won't work with Fb 2 unless it uses the Services API function. But, if
you have this program, why not test it yourself? ;-)

>I need to run this from VB.

Assuming you are using the Firebird ODBC driver, your best bet would be to
ask on the firebird-odbc list, as to what it has implemented.

But bear in mind that there's nothing that will report of users connected to
a specific database. And, with Classic, you will get one user back - being
the one that is running the process from which the request was made.

./heLen





[Non-text portions of this message have been removed]