Monitoring Open Files with ADS

[Tim K]

In Microsoft Server, ADS seems to render Console 1 useless for identifying who has files open. I see in the Advantage configuration utility it shows that there are files open but they are anonymous. Is there a simple way to monitor who has files open while using free tables?

[Cliff Wiernik]

Use the Advantage Database Architect. It tells you what users are connect, what IP address, if from terminal server, both that address and local workstation address. What files are opened. If you go to what files are opened, it will show you the user's login name. Login name is also shown on users connected listing.

This utility, written in delphi by Sysbase/Extended/SAP, is updated regularly, used to setup and configure data dictionaries, and also provides alot of the information that is in the advantage configuration utility.

We use it all the time and it can also be used to forceably disconnect users.

Some of the information can also be provided via the Xbase++ ADS sample programs, but do not work as good as this.

Cliff

[Tim K]

Thanks, Cliff. That works great.