Troubleshoot database integration with ASP or ASP.NET

Microsoft Office FrontPage 2003

ShowYour Web site might be hosted on an incorrectly configured Web server

A Web site based on ASP or ASP.NET can display interactive views of desktop-based or server-based data by using ASP code or ASP.NET controls.

To use ASP, the following technologies are required on your Web server:

To use ASP.NET, the following technologies are required on your Web server:

Contact your Web server administrator or Internet service provider (ISP) for more information.

ShowYour Web site location starts with C:\ instead of http://

To display interactive views of data based on ASP or ASP.NET, a Web site must be hosted on a server that uses the 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 at the top of the Folder List begins with http://. An example of a valid location is http://www.example.com/subsite1.

    If the location appears to be a path to a local or network location— such as C:\Documents and Settings\User\My Documents\My Web Sites\Subsite1— you'll need to create a Web site at a location that uses the HTTP protocol. A Web site on a local or network drive is not a valid location to display database-enabled 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://. An example of a valid location is http://www.example.com/subsite1.

    Do not use a local or network location— such as C:\Documents and Settings\User\My Documents\My Web Sites\Subsite1. Instead, create a Web site at a location that uses the HTTP protocol. A Web site on a local or network drive is not a valid location to display database-enabled pages.

ShowYour database page might not be saved with the correct extension

To display the contents of a database results region on your Web page, the file must have an extension of .asp for Web sites running Active Server Pages (ASP) or .aspx for Web sites running ASP.NET. A standard .htm or .html extension is not valid.

ShowMy database-enabled 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 file is not activated to allow scripts to run.

  1. In the Folder List, right-click the folder your page is stored in.

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

ShowI 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.

ShowYou're using a Web site based on Microsoft Windows SharePoint Services

  • Web sites located on servers running on Windows SharePoint Services use a different set of features to display data. To display data on a Web site based on Windows SharePoint Services, click the Data menu, and then click Insert Data View.

ShowYou're using a disk-based Web site

  • When you open the site in Microsoft FrontPage, check to see that the location specified at the top of the Folder List begins with http://. An example of a valid location is http://www.example.com/subsite1.

    If the location appears to be a path to a local or network location— such as C:\Documents and Settings\User\My Documents\My Web Sites\Subsite1— you'll need to create a Web site at a location that uses the HTTP protocol. A Web site on a local or network drive is not a valid location to display database-enabled pages.

ShowYour authoring settings do not allow Active Server Pages (ASP)

  1. On the Tools menu, click Page Options.

  2. Click the Authoring tab.

  3. In the FrontPage and SharePoint Technologies area, select the Active Server Pages check box.

ShowYour authoring settings do not allow Author-time Web Components

  1. On the Tools menu, click Page Options.

  2. Click the Authoring tab.

  3. Select the Author-time Web Components check box.

ShowYou'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.

ShowYour 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:

A Web site based on ASP or ASP.NET can display interactive views of desktop-based or server-based data by using ASP code or ASP.NET controls.

To use ASP, the following technologies are required on your Web server:

To use ASP.NET, the following technologies are required on your Web server:

Contact your Web server administrator or Internet service provider (ISP) for more information.

ShowI can run the Database Results Wizard but can't finish it because of errors.

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

To add a username and password, do the following:

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

  2. Click the database connection you want, and then click Modify.

    The Database Connection Properties dialog box appears.

  3. Click Advanced.

    The Advanced Connections Properties dialog box appears.

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

ShowThe OK button is unavailable when I add a database connection.

In the New Database Connection dialog box, after you click an option, click Browse to specify a URL for the database.

If you do not click Browse and then specify a URL, you will not be able to complete the task and return to the Database tab in the Site Settings dialog box.