I have used a approach where I make a socket app service. This app is
running on server. I have a ini file with only the IP numbers from LAN that
can get access to IB database. This IP´s are entered manually by
adminstrator when configuring the socket app server. For sample, if only 10
clients will can access the database, my inifile will have 10 IP numbers of
this workstations.
On Client app, I use sockets to connect to server app. If the IP from client
app is listed on my inifile, the app server will send a response to client
app allowing to access the database.
If one workstation crashes, no problem. It´s sufficient this workstation
connect again to server. As additional security, the tcp messages between
server and client are cryptographed.

Luiz.

----- Original Message -----
From: "Jason Fischer" <jfischer@...>
To: "Delphi Programing (E-mail)" <delphi-programming@yahoogroups.com>;
"IBObjects (E-mail)" <IBObjects@yahoogroups.com>
Sent: Wednesday, August 21, 2002 2:40 AM
Subject: [IBO] Controlling amount of users logged in


> Hi all
>
> I am writing an app that requires me to only let a certain number of users
> log in at the same time.
> I am using D5, Firebird and IBO for this.
>
> I have a user name and password that gets used to automatically log into
> firebird.
> I then have a table with users in it that I use to verify if the entered
> user name and password are valid.
> When this gets gone I update a flag that says that the user is logged in.
> When they log out the flag then gets updated to false.
> I use a query to do all this.
>
> 1) What I want to do is only allow a certain amount of users to access the
> program at once.
>
> 2) My other concern is what happens if the machine bombs out and the
logged
> in flag never gets reset, how do I know if the logged in flag is still
> valid.
>
> Any help and suggestions would be much appreciated.