FP2000: Database Connection Appears Broken on Personal Web Server 1.0a (232612)

SYMPTOMS

When you add or change a database connection by using the Database Results Wizard on ASP pages that are hosted on Personal Web Server 1.0a, you may receive the following error message:

Database Results Error
The database connection named 'database1' is undefined.

This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have scripting permissions enabled
* the web is not marked as an application root

In FrontPage, the database verifies correctly; yet, you still receive the error when you preview the page in the browser.

CAUSE

In addition to the possible causes listed in the error message, Microsoft Personal Web Server 1.0a sometimes caches the global.asa file. The global.asa file contains the information that is used for the ASP page to connect to the database when it is viewed from a browser.

If you add an additional database connection, or modify an existing one, the global.asa file is updated. However, when you preview your ASP page in the browser, it may not be using the most current version of the global.asa file.

MORE INFORMATION

You can work around this behavior by starting and stopping the Web server. This resets the connection and session status for the Web server.

To do this on Microsoft Personal Web Server 1.0a, follow these steps:

Click Start, point to Settings, and then click Control Panel.
In the Control Panel, double-click the Personal Web Server icon.
Click the Startup tab.
Click the Stop button.
After the Web server is stopped, click the Start button.