Help and Support
 

powered byLive Search

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

Article ID:272317
Last Review:August 5, 2004
Revision:2.2
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 (http://download.microsoft.com/download/fp2000/utility/1.0/win98me/en-us/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 (http://support.microsoft.com/kb/119591/EN-US/) 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.

APPLIES TO
Microsoft FrontPage 2000 Standard Edition
Microsoft FrontPage 98 Standard Edition

Back to the top

Keywords: 
KB272317

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.