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:
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 drive:
\Temp and drive:
\Tmp folders if they do not exist (where drive is the drive on which Windows is installed). To do this, follow these steps:
- On the Web server computer, start Windows Explorer, and then browse to the drive on which Windows is installed.
- On the File menu, point to New, and then click Folder.
- Name the folder Temp, and then press ENTER.
- Right-click the Temp folder, and then click Properties on the shortcut menu that appears.
- Click the Security tab. Verify that the Everyone group has at least Read and Write permissions to the folder.
- 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:
- On the Web server computer, click Start, click Settings, click Control Panel, and then double-click the System icon.
- 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.
- Under System Variables, search for the TEMP and TMP variables. Do one of the following:
- If these variables exist, verify that the path is correct.
- 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.
- On the Web server computer, click Start, and then click Run.
- In the Open box, type regedt32, and then click OK.
- Select the HKEY_LOCAL_MACHINE on Local Machine window.
- Double-click SOFTWARE, and then click ODBC.
- On the Security menu, click Permissions.
- Click Add, click Everyone in the Name list, click Add, click OK, and then click OK again.
- 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:
- 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.
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:
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
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