Hello,

> how can I view active connections in firebird 2.1 (latest release)? Do I
> need a separate tool for it? I use the EMS Firebird Manager to manage our
> databases.

Once connected to an ODS 11.1 database, you can execute the following
query to get the currently connected users to the database.

select * from mon$attachments;



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com