Subject | User Connections - ODBC Connections |
---|---|
Author | bill_zwirs |
Post date | 2005-11-24T09:25:26Z |
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.
Thamks in advance
Bill
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.
Thamks in advance
Bill