Hi Rob.

Killing the application will not automatically kill your database
connection. Your process may still exists in the database because before you
killed your app, you may have issued a command to the database for
processing, so while you app sits and seems like its hanging, in the
background, the database Server in your Win 2003 server is still going about
its tasks, performing whatever it needs to process for the app request. I
imagine that the user is running some form of Report which normally takes
about 20 minutes. So by the time the data needs to returned, there is no
handle to receive the data.
Solution
I think that the best way to resolve your problem is to kill the user
process from the Database Server. Currently I do not know how one can
database user process IDs. I am sure you will be getting more help from the
Firebird community. Thats my 2 cents worth, and I am surely others will
evaluate my analysis and correct where need be.

----- Original Message -----
From: "Robin Cumming" <rgc4000@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, September 15, 2005 10:42 AM
Subject: [firebird-support] User lockouts


> We are using Firebird 1.5x on a Win2003 server with a Delphi 5 based
> application. We are experiencing hangs in the application (no doubt
> due to bad code), the user then ends the process/application with task
> manager, and restarts the application. However Firebird will not allow
> the user to re-connect for about 20 minutes. The program uses IBX
> components to test whether the user is connected to FB, and FB reports
> the user is still connected even after disconnecting and re-starting,
> thus the 20 minute wait.
>
> Any suggestions on the cause of the problem and what we can do to fix ?
>
> Many thanks
>
> Rob Cumming
> rcumming@...
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>