I receive the error 'Program halted. Database error...'
This error is the result of one of two different problems. Either one of WebGate's modules has lost contact with the WebGate database, or there is some corruption in the WebGate database. If the WebGate module that reports this error is running on a different computer than where the WebGate database file resides, chances are you have a network connectivity problem (possible an intermittent one). If the WebGate module that reports this error is running on the same computer as the WebGate database file, there is most likely corruption in the WebGate database. Corruption is caused by one of the following conditions:
1. Abnormally terminating WebGate
- WebGate should ALWAYS be shut down in an orderly manner. WebGate's administration program should be exited before shutting down the computer that WebGate runs on. Next, each of WebGate's modules should be set to a 'stopped' state (red in WG Monitor). The WebGate service manager should be stopped by clicking on the pager icon in the Windows system tray and then choosing 'Quit' or 'Stop' from the popup menu. All of the above should be done before shutting down or restarting the computer that WebGate is running on. Not following these procedures can in some cases cause database corruption.
2. Freezing, locking, abnormal shutting down/rebooting, or other hardware failures
- If any computer that is running ANY part of WebGate freezes, locks up, reboots, shuts down, catches on fire, etc. without using normal shutdown procedures, in some cases can cause corruption in the WebGate database.
3. Operating system errors
- If computers running ANY part of WebGate receive errors such as: 'the blue screen of death', general exception errors, processor exception errors, illegal instruction errors, page fault errors, etc., in some cases the WebGate database can become corrupt.
4. Incorrect or out-of-date database support files
- WebGate uses the Microsoft Jet database engine (common with MS Access 97) for data access. If any of the database engine files are out of date (older versions are buggy), corruption can appear in the WebGate database. Please refer to the section 'File version problems' in the 'Troubleshooting' chapter of the WebGate help file for more details.
5. Bad or out-of-date operating system files.
- If WebGate is running on Windows NT, be sure that the NT Service Pack 5 or later is installed on all computers that run ANY part of WebGate.
- If WebGate is running on Windows 95 or 98, make sure ALL computers that run ANY part of WebGate have the current Windows redirector and OLE files. In particular, there is a serious problem with the redirector shipped with some versions of Windows 95 that will almost certainly cause database corruption. Please refer to the section 'File version problems' in the 'Troubleshooting' chapter of the WebGate help file for more details.