"Brad Pepers" <brad@...> wrote in message
news:20020202165330.9A55AD85D@......

> Is there any way to count users or to set a user limit for Firebird? I

know

> that since its open source it doesn't have licenses by users but anyone

using

> Firebird in a commercial software product would sure still like to have

the

> ability to set a limit! If I can't set the limit in Firebird, is there an
> API command that will return the count of currently connected users or at
> least how many the Super Server thinks are connected? This is only a

problem

> for me on Windows where it all runs in the Super Server. On Linux using

the

> Classic version, I can create a daemon that starts Firebird but counts

users

> properly. Now how to do so for Windows???

API Guide, "Working with Databases":

isc_database_info API call.
[snip]

Environmental characteristics.
Several items are provided for determining environmental characteristics,
such as the amount of memory currently in use, or the number of database
cache buffers currently allocated. These items are described in the
following table:
[snip]
user_names - Names of all the users currently attached to the database; for
each such user, the result buffer contains an isc_info_user_names byte
followed by a 1-byte length specifying the number of bytes in the user name,
followed by the user name.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing