FP2000: Installation of ASP.EXE may Interfere with Database Connectivity in Office 2000

ID: Q199365

The information in this article applies to:

SYMPTOMS

When you attempt to install Microsoft Active Server Pages (ASP.EXE) to an Internet Information Server version 3.0 or a Microsoft Personal Web Server version 1.0 after you have installed FrontPage 2000 or Office 2000, you may receive the following error message during the installation:

Incorrectly registered, run 'regsvr32.exe' to register
This error may be presented multiple times. An error similar to one of the following may be shown next.
Adding ODBC DSN entry for ADVWORKS

or
Adding ODBC DSN entry for ADOsamples
After you install Active Server Pages, some database features in FrontPage 2000 may not work correctly. The Database Results Region may return the following error when it is viewed in a Web browser.
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'fp_rs.State'
/_fpclass/fpdbrgn1.inc, line 181
Or, the Database Results Region may simply return no records when you view a page that contains a query which should return records in a Web browser.

In addition, the Saved Fields tab of the Save to Database form field handler will not be able to obtain a list of fields in the target database.

These problems will not occur you clear the option to install the ODBC 3.0, ADO, and OLE DB component when you install ASP.


CAUSE

The default installation of Microsoft Active Server Pages overwrites critical registry entries that relate to the proper functioning of FrontPage 2000 database features.


RESOLUTION

To resolve this problem, follow these steps.

Method 1: Repair the Installation

Use the FrontPage 2000 or Office 2000 setup program to repair the FrontPage 2000 or Office 2000 installation. You may also initiate this action by clicking Detect and Repair on the Help menu of any Office 2000 application.

Method 2: Re-Apply MDAC

Download Microsoft Data Access Component(MDAC) version 2.1 or higher from the following Microsoft World Wide Web site. http://www.microsoft.com/data/download.htm

Method 3: Upgrade your Web Server

The Windows NT Option Pack contains Internet Information Server version 4.0, as well as the Microsoft Personal Web Server. Note that the Microsoft Personal Web server version 4 will not support remote authoring with FrontPage. Also, it does not provide a security architecture or an FTP service.


STATUS

The installation of ASP was not designed to preserve existing registry entries related to database components if you select the option to install ODBC 3.0, ADO, and OLE DB. If you clear this check box during the installation of ASP, the problems described in this article are avoided.

Additional query words: 2000 2k fpodbc front page 


Keywords          : kbdta 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 1, 1999