Problems exist where a network dropout or a computer failure will 'lock' a terminal, and the user will not be able to log into System Five until the lock is reset. This is a Windows issue that can be easily resolved.

The default Microsoft Windows timeout value for improperly disconnected TCP/IP connections is two (2) hours. While it is possible to use the Pervasive Monitor Utility to manually delete these sessions, it is generally not recommended as it can be very easy to remove the wrong user or all users.

By changing the TCP/IP timeout value on the server you can reduce the delay from the default two(2) hours to three (3) minutes. This should not be done on the workstations. It should only be done on the server.

  1. Open the Microsoft Windows Registry Editor ( START / RUN / Regedit <enter> )
  2. Browse to the “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters” key
  3. Locate the Value “KeepAliveTime”. If it does not exist, create a new REG_DWORD Value called “KeepAliveTime”
  4. Set the Value “KeepAliveTime” to decimal 180000
  5. Exit the registry editor
  6. Reboot your machine for the changes to take effect

Please be aware that the capitalization in KeepAliveTime is important!

The “KeepAliveTime” setting affects the whole TCP/IP protocol stack not just Pervasive.SQL. This information is also on the Microsoft Knowledgebase, go to:

Registry edit screenshot: