Subject Re: User lockouts
Author Robin Cumming

We use 1 database component (in Delphi) for the app to connect to
Firebird. All queries are routed through this single connection. The
app itself does not open other connections in parallel to Firebird.
Each user has their own login to Firebird, which we check with
Firebird before allowing them to login to the database.


--- In, "Alan McDonald" <alan@m...>
> >
> > Adam,
> >
> > Yes Firebird definitely thinks the user is still connected, as we
> > use the IBX Admin components to determine whether the user is
> > in or not. The Admin component apparently gets the logged in
> > from Firebird itself. And the program will not let the user re-
> > connect while Firebird still rpeorts the user as connected.
> >
> > Is it possible that once the client disconnects via task manager
> > Firebird then starts a rollback process, and only when this is
> > completed will Firebird release the connection ?
> >
> > Rob
> >
> what do you do when your application needs to make a second or
> connection itself, legitimately?
> Alan