Subject | UserNames connected to my database |
---|---|
Author | |
Post date | 2015-07-28T11:25:51Z |
Hi. I have a problem. I use a Firebird 1.5.6 Server for a lot of applications, 5 databases on the same server.
I need to find the number of connection for a single database, and the names of the users. For this i used IBX IBDatabaseInfo->UserNames->Count and IBDatabaseInfo->UserNames->Strings[i], in Builder C++.
The problem is if i have started a lot of application, the number of connections is the TOTAL connections to the SERVER, not only for my database. I have only one connection to my TIBDatabase, but IBDatabaseInfo->UserNames->Count report 3, with 2 connection to another application, different database!!!
Give my a valid solution to find only UserNames connected to my database!!!
Thanks
I need to find the number of connection for a single database, and the names of the users. For this i used IBX IBDatabaseInfo->UserNames->Count and IBDatabaseInfo->UserNames->Strings[i], in Builder C++.
The problem is if i have started a lot of application, the number of connections is the TOTAL connections to the SERVER, not only for my database. I have only one connection to my TIBDatabase, but IBDatabaseInfo->UserNames->Count report 3, with 2 connection to another application, different database!!!
Give my a valid solution to find only UserNames connected to my database!!!
Thanks