FIX: MSOLAP Providers Not Displayed in SQL Server Enterprise Manager After You Upgrade to Microsoft Data Access Components 2.7

Certain tools, such as the SQL Server Enterprise Manager, may not display the Microsoft OLE DB Provider for OLAP Services and Microsoft OLE DB Provider for OLAP Services 8.0 in the list of providers after you upgrade to Microsoft Data Access Components 2.7 (MDAC).

In MDAC 2.7, the root enumerator component of the core OLE DB services code incorrectly enumerates the registry keys for the Microsoft OLE DB Provider for OLAP Services and Microsoft OLE DB Provider for OLAP Services 8.0.

Essentially, the root enumerator lists all of the OLE DB providers by searching each CLSID registry key for an OLE DB provider key, an OLE DB MD provider key, or an OLE DB enumerator key. If a CLSID registry key contains an OLE DB provider key, then the root enumerator lists the provider associated with that key as an OLE DB provider.

In MDAC 2.7, the root enumerator stops searching each CLSID registry key when the root enumerator encounters an OLE DB provider key, an OLE DB MD provider key, or an OLE DB enumerator key. The root enumerator ignores cases in which an OLE DB provider contains more than one of the three keys.

The MSOLAP providers contain both an OLE DB MD provider key and an OLE DB provider key. In the registry, the root enumerator finds the OLE DB MD provider key first and stops the search without locating the OLE DB provider key. Because the root enumerator does not find the OLE DB provider key, the Microsoft OLE DB Provider for OLAP Services and Microsoft OLE DB Provider for OLAP Services 8.0 are not included in the list of OLE DB providers.

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: The English-language version of this fix should have the following file attributes or later:

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.

Steps to Reproduce Behavior

On a computer that has Microsoft Data Access Components 2.7, Microsoft SQL Server 2000, and Microsoft SQL Server 2000 Analysis Services installed, following these steps:

1. Start SQL Server 2000 Enterprise Manager.
2. Click to select the appropriate server.
3. Click to select Data Transformation Services.
4. Right-click Local Packages, and then click New Package.
5. On the Connection menu, click Other Connection.
6. In the Connection Properties dialog box, review the list of providers in the Data source list box. The Microsoft OLE DB Provider for OLAP Services and Microsoft OLE DB Provider for OLAP Services 8.0 are not listed.