Troubleshoot database integration

My web page loads when I click Preview in Browser, but no data shows.

Your web site might be hosted on an incorrectly configured Web server

Database integration features of Microsoft FrontPage work when your web site is hosted on or published to a Web server configured with one of the following:

• Active Server Pages (ASP)

• Active Data Objects (ADO)

  Note   ADO is part of the Microsoft Data Access Components (MDAC). ADO is installed by default with Microsoft Office 2000, Office XP, and Microsoft Windows 2000.

• Microsoft FrontPage 2000 Server Extensions (or later edition) or SharePoint Team Services from Microsoft

• Internet Information Server (IIS) 4.0 (or later)

  Note   ASP is installed by default with IIS 4.0.

Check to see whether your Web server is configured with these options, or ask your Internet service provider (ISP) or web administrator for assistance.

Your web site location starts with C:\ instead of http://

A data-enabled web site should be hosted on or published to a server using HTTP protocol. When you open or create a web site to be used with a database, verify the following:

• If you've already created a web site   When you open the site in Microsoft FrontPage, check to see that the location specified in Web name begins with http://. For example, a valid location for your database-enabled web site might look like this: http://web.microsoft.com/Web1.

  If the location begins with a file designator (such as C:\Documents or Settings\User\My Documents\My Webs\Web1), you'll need to create a web site at a location using the HTTP protocol. A file-based web site is not valid for displaying database-integrated pages.

• If you need to create a web site   In the New dialog box, under Specify the location of the new web, the location you type must start with http://. For example, a valid location for your data-base enabled web site might look like this: http://web.microsoft.com/Web1.

  Do not use a file location (such as C:\Documents or Settings\User\My Documents\My Webs\Web1). A file-based web site is not valid for displaying database-integrated pages.

Your database page might not be saved with an .asp extension

To display the contents of a database results region on your web page, the file must have an extension of .asp. A standard .htm or .html extension is not valid.

Note   When you change the extension of a file to .asp in the Folder List, click Yes when Microsoft FrontPage prompts you to ask if you're sure you want to rename the file.

My database page won't load when I click Preview in Browser.

If you see the error message "HTTP Error 403 (403.1 Forbidden: Execute Access Forbidden)" in your browser window, the folder storing your .asp file is not enabled to allow scripts to run.

1. In Microsoft FrontPage Folder view, right-click the folder your .asp page is stored in.

2. Select the Allow scripts to be run check box.

I can't run the Database Results Wizard because Database is unavailable on the Insert menu.

There are several reasons why Database on the Insert menu might be unavailable.

You're working on a disk-based web site

• When you open the site in Microsoft FrontPage, check to see that the location specified in Folder name begins with http://. For example, a valid location for your data-base enabled web site might look like this: http://web.microsoft.com/Web1.

• If the location begins with a file designator (such as C:\Documents or Settings\User\My Documents\My Webs\Web1), you'll need to create a web site at a location using the HTTP protocol. A file-based web site is not valid for displaying database-integrated pages.

Your browser compatibility settings do not allow Active Server Pages (ASP)

1. On the Tools menu, click Page Options.

2. Select the Compatibility tab.

3. In the Technologies area, select the ASP check box.

Your browser compatibility settings do not allow features requiring Microsoft FrontPage Server Extensions

1. On the Tools menu, click Page Options.

2. Select the Compatibility tab.

3. Select the Enabled with Microsoft FrontPage Server Extensions check box.

You're not working in a web site

Check to make sure that you opened a server-based web site and not just a new page outside of a web site.

Your web site might be hosted on an incorrectly configured Web server

Database integration features of Microsoft FrontPage work when your web site is hosted on or published to a Web server configured with one of the following:

• Active Server Pages (ASP)

• Active Data Objects (ADO)

  Note   ADO is part of the Microsoft Data Access Components (MDAC). ADO is installed by default with Microsoft Office 2000, Office XP, and Microsoft Windows 2000.

• FrontPage 2000 Server Extensions (or later version) or SharePoint Team Services from Microsoft.

• Internet Information Server (IIS) 4.0 (or later)

  Note   ASP is installed by default with IIS 4.0.

Check to see whether your Web server is configured with these options, or ask your Internet service provider (ISP) or web administrator for assistance.

I can run the Database Results Wizard but can't finish it due to errors.

If the server encounters an error when trying to retrieve a record source in Step 2 of the Database Results Wizard, you might be attempting to access a password-protected database without proper authentication.

Add a username and password

1. On the Tools menu, click Web Settings, and then click the Database tab.

2. Select the database connection you want to use, and then click Modify.

   The New Database Connection dialog box appears.

3. Click Advanced.

   The Advanced Connections Properties dialog box appears.

4. Under Authorization, type the correct username and password.