bill_zwirs wrote:

> I want to show (on a status bar) the number of users connected to the
> application's database. I currently use a LMD component to do this.
> The application uses Crystal Reports so as soon as a report is run the
> additional connection (ODBC) is included in the User connection
> count. The ODBC connection normally remains until the application is
> shut down. Is there a way - by using SQL - to determine the number of
> users connected to a Firebird database and determine separate numbers
> of actual users and ODBC connections.

You could create separate user accounts for ODBC connections, that you
be named ODBC_1, ODBC_2, etc. That way you would see ODBC connections as
different users, and count them separately.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org