Subject | Connected user. |
---|---|
Author | Michael Vilhelmsen |
Post date | 2007-01-04T12:54:45Z |
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
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