| Breck Carter [TeamSybase] 2005-07-22, 9:23 am |
| You can run a FETCH loop on a procedure call to sa_conn_info() to get
information about each connection, perform your own selections and
calculations.
If you upgrade to SQL Anywhere 9 you could do
SELECT COUNT(*) FROM sa_conn_info()
Understand that you cannot run *both* dbsrv6.exe and dbeng6.exe on the
same database file at the same time.
Breck
On 22 Jul 2005 06:04:52 -0700, "Naimesh Trivedi"
<nbtrivedi@hotmail.com> wrote:
>Hello ! I am using PB 7.x with ASA 6.x. I wanted to know is there any way to check how many connections to ASA from the same or network computers if database is open using dbsrv.exe in one machine and using dbeng.exe in rest of. ?
>
>This i want to do from pb application.
>
>Thanks & Regards,
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|