I have a webapp that connects to a Gupta database via ODBC.
I open the odbc connection in the webserver
Works like a charm. If however in a DMZ zone with a TCP timeout a timeout occurs, then the webapp does not see the tables anymore.
The webapp is on a seprate server as the database. For security reasons there is a timeout set on the tcp connection.
What is the best practice in this case?
.
Can I check the connection in the webhandler?
Should I make a separate windows program that checks if the connection is open and restart the webapp ?
Topic: lost connection odbc (Read 2539 times)