> Hi
>
> We have a database server running FB 1.5.3 SS.
>
> The users connect to this server from a Windows Terminal Server or a
> Citrix (at least those I'm going to mention here).
>
> Sometimes a connection to this terminal server is lost or broken.
> And after a few minutes the terminal server terminates the connection
> between client and terminal server, adn there by terminating the
> running program (and there by terminating the connection to Firebird).
>
> Or a user has a abnormal termnination of our program (by some fault of
> mine maybe).
>
>
> When this happens then in most cases Firebird sees that to connection
> was lost, and disconnect the user.
> But every so often Firebird never sees this - And the user stays online.
>
> This is a problem for us. Upon starting our program we see if this
> user is already connected. If he is (as in the above example) he is
> not allowed to start the program.
>
>
> What causes Firebird to see a lost connection ?
> Can I do anything to change this behavier ?
>
> What we do now is stopping and starting Firebird.
> But we can't do that until in the middle of the nigth.
>
>
> This problem is only present when using a terminal server.
>
> Michael

FB will continue to see the lost connection until the timeout for inactive
connections is triggered. In which case the transactions will be rolled back
and resources reclaimed.
Sounds like a good argument for not preventing multiple user connection OR
waiting the timeout OR adjusting the timeout in the conf file.
http://support.microsoft.com/default.aspx?kbid=140325
as per release notes.
Alan