HP3000-L Archives

September 2001, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Lars Appel <[log in to unmask]>
Reply To:
Lars Appel <[log in to unmask]>
Date:
Sat, 22 Sep 2001 14:15:37 +0200
Content-Type:
text/plain
Parts/Attachments:
text/plain (28 lines)
Mike after Jacek wrote...

> > How can I see who is connected to TurboIMAGE by ODBC?

>There are several ways to see this assuming you are using ODBCLINK/SE.
>1.  LISTF ODBCLOG.ODBCSE.SYS,9
>2.  LISTF Your Allbase DBE file,9

Unfortunately those two will only show the server process PIN number
and program file, not the user's MPE logon or client's IP address. On
7.0 (express-1 ?) however, you can use the PINFO function here...

 :calc pinfo( nnn, "FmtEUID")   -- shows the effective UID
 :calc pinfo( nnn, "IPaddr")    -- shows the client's IP addr

>3.  RUN SQLMON.PUB.SYS
>    SET DBENV Your Allbase DBE
>    p for program and look for program ODBCLNSE.ODBCSE.SYS
>    This is the most effective because it will show session, user and
>    account information.

Wow. That's a cool one. Thanks for sharing, Mike!

Lars.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2