Hmm ... if I remember correctly there isn't a way...
but you could use the "SHOW STATISTICS FOR DATABASE dbName" command
to get useful information about a single database (it reports also
total number of connection occurred).
Regards,
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
On Aug 12, 2006, at 12:12 AM, Dr Gerard Hammond wrote:
Hi,
Besides doing this...
dim rc as RecordSet
dim i as integer
rc = SQLselect("SHOW CONNECTIONS")
if rc <> nil then
i = 0
while not rc.EOF
i = i + 1 //spin and count
rc.MoveNext
wend
rc.Close
Return i
end
Return -1
Is there a more reliable method to get the number of connected
users, connected to a single database on a REAL SQL server, serving
several dbs?
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
