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