FP: How to Use ADOSelect to Troubleshoot ASP Pages in FrontPage

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

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.