Database Region Fails after Publish

• Microsoft FrontPage 2000 Server Extensions
• Microsoft FrontPage 98 for Windows

SYMPTOMS

When you publish a Web site that contains a database region that is located in a subweb, the database region fails with the following error message:

Database Results Error
The database connection named 'database' 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 

CAUSE

When a subweb is published to an IIS computer, FrontPage creates the subweb as an application root. This causes a problem for the ASP page because the Global.asa file is in the wrong place based on the application settings.

WORKAROUND

To work around this behavior do the following:

1. Click Start and point to Programs.



2. Point to Windows NT 4.0 Option Pack and then point to Microsoft Internet Information Server.



3. Click Internet Service Manager.



4. Click the plus sign (+) next to the Web site in question and expand the folders until you get to the subweb containing the ASP page that references the database.



5. Right-click the subweb and click Properties.



6. On the Directory tab, click the Remove button in the Application Settings.



7. Click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: front page

Keywords : fpse2000
Version : WINDOWS:; winnt:
Platform : WINDOWS winnt
Issue type : kbbug