You receive a connection error message when you use the Database Results Wizard (216900)
The information in this article applies to:
- FrontPage 2000 Server Extensions from Microsoft
This article was previously published under Q216900 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.
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. 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.
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.
MORE INFORMATION Note that FrontPage 2000 Database features work only on Web
servers running ASP.
Modification Type: | Minor | Last Reviewed: | 10/19/2004 |
---|
Keywords: | kbADO kbDatabase kbwizard kberrmsg kbnofix kbprb KB216900 |
---|
|