FP: How to Use ADOSelect to Troubleshoot ASP Pages in FrontPage (272317)


The information in this article applies to:

  • Microsoft FrontPage 2000
  • Microsoft FrontPage 98 for Windows
This article was previously published under Q272317

SUMMARY

This article describes how to use the file ADOSelect.asp to troubleshoot ASP pages that are generated by a Microsoft FrontPage 2000 Database Results Region or a Microsoft FrontPage 98 Database Results Wizard.

If an ASP page generated by FrontPage produces an error message or does not function as expected, ADOSelect.asp can be used to determine whether the Web server on which the ASP page is running is configured correctly to run ActiveX Data Objects (ADO) pages. (ASP pages generated by FrontPage use ADO for database connectivity.)

MORE INFORMATION

To use ADOSelect.asp to troubleshoot the ASP page, follow these steps:
  1. On the Web server, create a System Data Source Name (DSN) that points to the data source.
  2. Download ADOSelect.exe from the Microsoft Download Center.
    The following file is available for download from the Microsoft Download Center:

    ADOSelect.exe

    For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

    119591 How to Obtain Microsoft Support Files from Online Services

    Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
  3. Double-click ADOSelect.exe, and extract the ADOSelect.asp file to your desktop.
  4. Import ADOSelect.asp into the root folder of your web.
  5. Browse to ADOSelect.asp in your Web browser. Make sure that you browse to it by using HTTP. For example, browse to:

    http://localhost/myweb/adoselect.asp

  6. Type the System DSN name.
  7. Type a user name and password if the data source requires it. If no user name or password is required, type anything for the user name.
  8. Type the name of the table to query against in the data source. All other form fields can be left empty.
  9. Click the Query Database button.
If data is returned, ADO is correctly configured on the Web server.
Modification Type:MinorLast Reviewed:8/5/2004
Keywords:KB272317
©2004 Microsoft Corporation. All rights reserved.