User names and number.

By: Ben Matterson

Abstract: A quick answer on how to get a list of connected users.

Question:

How do I get the number and names of connected users?

Answer

One way is to use the TIBDatabaseInfo component that comes with Delphi. Another, more complicated way, is to use the InterBase services API. For more information using the InterBase services API see the "InterBase API Guide", chapter 12, "Working With Services".

Also, if you are using InterBase 7 you can get this information from the temporary table TMP$ATTACHMENTS. For more information on the information contained in TMP$ATTACHMENTS see the InterBase "Language Reference" chapter 7, "System Table, Temporary Tables, and Views".

Server Response from: ETNASC04