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