Help and Support
 

powered byLive Search

FP2000: Error Browsing Database Results Pages After Publishing from Disk-Based Web

View products that this article applies to.
Article ID:219170
Last Review:October 1, 2001
Revision:1.0
This article was previously published under Q219170
On This Page

SYMPTOMS

After you publish a disk-based Web to a Web server, you may receive the following error message when you preview the page in the browser on pages that contain database results regions:
Database Results Error
The database connection named 'DatabaseName' 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 permission enabled
* the web is not marked as a Application Root
where DatabaseName is the name of your database connection.

Back to the top

CAUSE

This behavior occurs when the Web is not marked as an application root.

The Web is not automatically created as an application root. Active Server Pages (ASP) and database features do not function unless the Web is part of an application root.

Back to the top

RESOLUTION

To resolve this issue, use one of the following methods.

Back to the top

Method 1: Verify the Database Connection

To verify the database connection, follow these steps:
1.Open the Web on the server.
a. On the File menu, click Open Web.
b. In the Folder Name box, type the name of the Web. (Example: http://localhost/myweb)
c. Click Open.
2.On the Tools menu, click Web Settings.
3.Click the Database tab.
4.Select the database connection, and click Verify. Repeat this steps for each database in the list.

Back to the top

Method 2: Set the Root Folder to Allow Programs to Be Run

To set the root folder to allow programs to be run, follow these steps:
1.Open the Web on the server.
a. On the File menu, click Open Web.
b. In the Folder Name box, type the name of the Web. (Example: http://localhost/myweb)
c. Click Open.
2.On the View menu, click Folders.
3.In the Folder list, right-click the top level folder, and then click Properties.
4.Click to select the Allow programs to be run check box, and then click OK.NOTE: On subfolders that contain ASP, you might need to right-click the folder and select the Allow programs to be run check box for ASP to function correctly.

Webs hosted on Microsoft Internet Information Server 4.o with FrontPage 2000 Server Extensions or on Internet Information Services 5.0 also need to have an application root created. Click the Directory tab in the Internet Service Manager, and then click Create.

Back to the top

Method 3: Create a New Page by Using the Database Connection

To create a new page using the database connection, follow these steps:
1.Open a new page in the Page view of FrontPage.
2.On the Insert menu, point to Database, and click Results.
3.In Step one of the Database Results Wizard, click to select the Use an Existing Database option, and select your database from the list.
4.Click Next, and accept all defaults.
5.When the wizard is finished, save the page to the Web (on the server).NOTE: After the initial page has been saved, you can delete the file that you created by using this method.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top

MORE INFORMATION

If you are hosting your Web on Internet Information Server 3.0 with FrontPage 2000 Server Extensions, please see the following article in the Microsoft Knowledge Base:
215365 (http://support.microsoft.com/kb/215365/EN-US/) Server Error: The Folder '/Cgi-bin' Is Marked Executable

Back to the top

APPLIES TO
•Microsoft FrontPage 2000 Standard Edition

Back to the top

Keywords: 
kbbug kbpending KB219170

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.