Microsoft KB Archive/310678

= FP2000: Error Message When You Attempt to Insert a Database Results Region into a FrontPage Web: &quot;Error '80004005' &quot; =

Article ID: 310678

Article Last Modified on 3/29/2007

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q310678



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you attempt to insert a database results region into a Microsoft FrontPage Web, you may receive an error message similar to the following:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft] [ODBC Microsoft Access 97 Driver] can't open database

'(unknown)'.

It may not be a database that your application recognizes, or the file may be corrupt.



CAUSE
This behavior can occur when you attempt to use the Database Results Wizard to connect to a Microsoft Access 97 database.



RESOLUTION
This article describes some of the common steps to take to troubleshoot this error message. It is not necessary to follow these methods in the order in which they are presented.

Test the OLE Connection
Create a sample Active Server Pages (ASP) Web page with an inserted Data Link File (UDL), and create a connection to the sample Northwinds database in order to test the OLE database connection.

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

189680 HOWTO: Use Data Link Files with ADO

165671 HOWTO: Use ASP/ADO to Query an ODBC Datasource (SELECT)

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

Verify the Existence of Temporary Folders
Create the \Temp and  \Tmp folders if they do not exist (where drive is the drive on which Windows is installed). To do this, follow these steps:
 * 1) On the Web server computer, start Windows Explorer, and then browse to the drive on which Windows is installed.
 * 2) On the File menu, point to New, and then click Folder.
 * 3) Name the folder Temp, and then press ENTER.
 * 4) Right-click the Temp folder, and then click Properties on the shortcut menu that appears.
 * 5) Click the Security tab. Verify that the Everyone group has at least Read and Write permissions to the folder.
 * 6) Follow steps 2 through 5 to create a TMP folder with sufficient access permissions.

For additional information about setting folder permissions in Windows, click the article numbers below to view the articles in the Microsoft Knowledge Base:

300691 HOW TO: Set Up a Windows 2000 File System for Secure Access

301281 HOW TO: Share Files and Folders Over a Network for Windows 2000

287024 Permission Inheritance Behavior in Windows 2000 and Windows NT 4

301195 HOW TO: Configure Security for Files and Folders on a Network

Verify the Access Permissions to the Winnt and ADO Folders
Verify that the Everyone group has at least Write and Read permissions to the following folders:

drive:\Winnt

drive:\Program Files\Common Files\System\ado

Verify the TEMP and TMP System Variables
Verify that the TEMP and TMP environment variables exist as system variables. To do this, follow these steps:
 * 1) On the Web server computer, click Start, click Settings, click Control Panel, and then double-click the System icon.
 * 2) If your computer is running Microsoft Windows NT, click the Environment tab. If your computer is running Microsoft Windows 2000, click the Advanced tab, and then click Environment Variables.
 * 3) Under System Variables, search for the TEMP and TMP variables. Do one of the following:
 * 4) * If these variables exist, verify that the path is correct.
 * 5) * If these variables do not exist, click New under System Variables. In the Variable Name box, type TEMP . In the Variable Value box, type c:\temp . Repeat this step to create a name and value for the TMP variable.

Edit Registry Permissions
NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

Assign Full Control permissions to the Everyone group for the following registry subkey:

HKEY_LOCAL_MACHINE\Software\ODBC

To do this, follow these steps.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.


 * 1) On the Web server computer, click Start, and then click Run.
 * 2) In the Open box, type regedt32, and then click OK.
 * 3) Select the HKEY_LOCAL_MACHINE on Local Machine window.
 * 4) Double-click SOFTWARE, and then click ODBC.
 * 5) On the Security menu, click Permissions.
 * 6) Click Add, click Everyone in the Name list, click Add, click OK, and then click OK again.
 * 7) Quit Registry Editor.

Test Microsoft Data Access Components
Use the Microsoft Component Checker (ComCheck) utility to test the Microsoft Data Access Components (MDAC). To obtain the ComCheck utility, follow these steps:  See the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/data/aa937695.aspx

 Click MDAC Utility: Component Checker Version 2.7. In the File Download dialog box, click Save this program to disk, and then click OK. In the Save As dialog box, click Desktop in the Save in box, and then click Save.

NOTE: The file name that is listed should be cc.exe. When the download process is complete, click OK. Double-click the self-extracting cc.exe file, and then extract the ComCheck tool to the C:\comcheck folder.

NOTE: To start the ComCheck tool, use the command line, or double-click the ComCheck.exe icon in the C:\Comcheck folder.</li></ol>

For additional information about troubleshooting MDAC, click the article number below to view the article in the Microsoft Knowledge Base:

232060 HOWTO: MDAC Setup Troubleshooting Guide

Reinstall the Jet Database Service Pack
To obtain the latest service pack for Jet 4, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/results.aspx?productID=&freetext=JET+service+pack&DisplayLang=en

For additional information about how to identify the Jet database components, click the article number below to view the article in the Microsoft Knowledge Base:

141796 HOWTO: Identify the Jet Database Engine Components

<div class="moreinformation_section">

MORE INFORMATION
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

237977 INFO: OLE DB Session Pooling Timeout Configuration

197323 HOWTO: Troubleshoot ADODB.Connection Error 800a0bb9

Additional query words: front page Microsoft OLE DB Provider for ODBC Drivers error 80004005 Access 97 Driver can t open database unknown

Keywords: kbprb KB310678

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.