Microsoft KB Archive Search

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.

  1. Home
  2. PRB: Cannot Enumerate OLE DB Providers

PRB: Cannot Enumerate OLE DB Providers

View products that this article applies to.

This article was previously published under Q260145
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� (http://support.microsoft.com/kb/256986/EN-US/ ) Description of the Microsoft Windows Registry

↑ Back to the top

Symptoms

When you attempt to create a link to an OLE DB datasource by using the Universal Data Link (UDL) wizard on the desktop, the import\export wizard, or the Data Transformation Services (DTS) designer, the available OLE DB providers are not enumerated.

↑ Back to the top

Cause

The problem can be caused by a bad entry in the registry at HKEY_CLASSES_ROOT\CLSID. The bad entry may resemble the following (but much longer):
000????????????????????????????????
The entry is easy to find because is the first entry in the key.

↑ Back to the top

Resolution

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. Start Registry Editor (Regedt32.exe).
  2. Locate the following key in the registry: 
    HKEY_CLASSES_ROOT\CLSID\000<<<<<<<<<<<<<<<<<<<...<<<<<<
    NOTE: In this registry key, the "..." represents about 180 boxes. The number of these characters is not important. If you see an entry that resembles this, it is probably the problem entry.
  3. On the Edit menu, click Delete, and then click OK.
  4. Quit Registry Editor.

↑ Back to the top

Keywords: KB260145, kbprovider, kbprb, kbdatabase

↑ Back to the top

Article Info
Article ID : 260145
Revision : 3
Created on : 5/10/2003
Published on : 5/10/2003
Exists online : False
Views : 333