Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You receive a connection error message when you use the Database Results Wizard


View products that this article applies to.

This article was previously published under Q216900

↑ Back to the top


Symptoms

When you use the Database Results Wizard, the following error occurs:
The server encountered an error while processing a database request. For more information, click Details:

If you click the Details button, an error similar to the following occurs:
Server error: Unable to retrieve the list of record sources from a database using the connection string:

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/database.mdb.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------

Source: ADO
Number: -2146824584 (0x800a0e78)
Note that the actual text of the error may vary depending on the type of database you are attempting to connect to.

This error is only produced in the Database Results Wizard if you are connecting through one of the desktop database ODBC drivers. These errors do not occur connecting to a SQL Server data source.

↑ Back to the top


Cause

Database functionality in FrontPage 2000 uses Active Server Pages (ASP) to call ActiveX Data Objects (ADO). Not all of the ADO components are installed on the server. This is the case if the server administrator installs the FrontPage 2000 Server Extensions and does not install the FrontPage 2000 Client on the Web server or does not separately install MDAC 2.1. The installation of the FrontPage 2000 or Office 2000 client installs all of the required database functionality.

↑ Back to the top


Resolution

There are two methods for the Web server administrator to resolve this problem.

For all supported Web servers running on Windows:

Install Microsoft Data Access Components 2.1 or later on the Web server. MDAC 2.1 can be downloaded from the following Web site:For all supported Web servers running on Windows x86 systems:

Install the FrontPage 2000 or Office 2000 client on the Web server.

↑ Back to the top


Status

This behavior is by design. The standalone FrontPage Server Extensions installation does not install MDAC 2.1.This problem was corrected in MDAC 2.5.

↑ Back to the top


More information

Note that FrontPage 2000 Database features work only on Web servers running ASP.

↑ Back to the top


Keywords: KB216900, kbprb, kbnofix, kberrmsg, kbwizard, kbdatabase, kbado

↑ Back to the top

Article Info
Article ID : 216900
Revision : 8
Created on : 5/17/2007
Published on : 5/17/2007
Exists online : False
Views : 422