NetTalk Central

Author Topic: Web server program with SQL stops suddenly  (Read 13581 times)

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11183
    • View Profile
Web server program with SQL stops suddenly
« on: March 26, 2009, 12:37:29 AM »
Marc Lebhertz reports the following information:

The database I am using is a SQL Anywhere database (but this must be the
same with Oracle or SQL server). The default parameter in SQL Anywhere is to disconnect a client after 240 minutes of inactivity.

So, say after a night, when I try to connect to the webserver, first screen
appears (login screen), but on the "do OpenFiles" before controlling user
password, the webserver closes, without gpf and without any message.

To work around, I have simply modified the default parameter so the
disconnect from the database server never occurs : and the webserver now
works fine since last Monday.

Cheers
Bruce