Subject | RE: [IB-Conversions] How to list the active connections to a IB 5.6 or FB 1.5.4 db |
---|---|
Author | Claudio Valderrama C. |
Post date | 2007-09-22T10:18:58Z |
> -----Original Message-----No queries. You need to call isc_database_info() or isc_service_query() to
> From: IB-Conversions@yahoogroups.com
> [mailto:IB-Conversions@yahoogroups.com]On Behalf Of MuraliM
> Sent: Jueves, 20 de Septiembre de 2007 0:01
>
> Hi,It would be helpful if i get any queries or commands to list
> the active connections for a database in Interbase 5.6 and
> Firebird 1.5.4.Thanks in advance
get them, as explained in my other answer.
Only if you are using FB 2.1 and newer you can do
select count(*) from mon$attachments;
and it will tell you how many attachments exist to the database you're
logged in.
C.