Kbase P4276: How to know which SQL-92 users are connected to the SQL-92 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/8/2002 |
|
Solution ID: P4276
GOAL:
How To Know The SQL-92 Users Connected to SQL-92 Database
FACT(s) (Environment):
Windows NT 4.0
Windows 2000
Progress 9.1C
Progress 9.1D
FIX:
Run this query from an ODBC or JDBC Application:
select * from pub."_connect" usr, pub."_connect" srv where srv."_connect-pid" = usr."_connect-pid" and srv."_connect-usr" = usr."_connect-server"