Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FP2000: Database Connection List Is Empty When You View Database Results Properties


View products that this article applies to.

This article was previously published under Q265323

↑ Back to the top


Symptoms

In Microsoft FrontPage 2000, when you view the Database Results properties, the database connection list may appear to be empty. When you create new valid database connections, this does not appear to change the state of the database connection list.

In addition, when you browse to previously working database results pages in the FrontPage web, you may receive the following error message:
Database Results Error
The database connection named 'Database1' is undefined.

This behavior 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

↑ Back to the top


Cause

This behavior can occur if the global.asa file either contains errors or has become corrupted.

↑ Back to the top


Resolution

To resolve this issue, re-create the global.asa.

To do so, follow these steps:
  1. Open your web in FrontPage.
  2. Rename the global.asa file.
  3. On the Tools menu, click Web Settings.
  4. On the Database tab, click Add.
  5. In the New Database Connection dialog box, configure as necessary to create a valid database connection.
  6. When you are finished, click OK.
  7. Repeat steps 4-6 as necessary to re-create all the database connections that you need for this web.
  8. When all the database connections have been re-created, click OK.
When you view the Database Results properties, the database connection list should now appear to be populated.

If you have existing pages that use the Database Results component, you need to reset them to the proper database connection by going into the Database Results properties.

After the database connection has been reset in the Database Results properties, the page should indicate that the database connection works.

↑ Back to the top


Keywords: KB265323, kbprb

↑ Back to the top

Article Info
Article ID : 265323
Revision : 2
Created on : 8/27/2002
Published on : 8/27/2002
Exists online : False
Views : 214