PRB: Unable to Register OLAP Client Files with MDAC 2.6 Installed (283880)



The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
  • Microsoft SQL Server OLAP Services 7.0 SP1
  • Microsoft SQL Server OLAP Services 7.0 SP2

This article was previously published under Q283880

SYMPTOMS

When you install an OLAP client application that uses the Microsoft OLE DB provider for OLAP on a clean computer that has only had Microsoft Data Access Components (MDAC) 2.6 installed, the OLAP client installation fails during the registration of certain DLL files.

If the clean computer already had an earlier version of MDAC installed (prior to MDAC 2.6), upgrading MDAC to 2.6 does not hinder the registration of the OLAP client DLLs.

CAUSE

In MDAC 2.6, the following files have been removed, which are required to correctly register the OLAP provider:
  • Sqlwoa.dll

  • Sqlwid.dll

  • Sqlstr.dll

WORKAROUND

To work around this problem, use either of the following methods:
  • Install the OLAP client on a computer that has MDAC 2.5 installed.

    -or-

  • Run the Sqlredis.exe file that comes with any of the Microsoft SQL Server 7.0 Service Packs. Sqlredis.exe is located in this folder:
     ..X86\Other folder
    The latest Service Pack for Microsoft SQL Server 7.0 is located at the following Web address:

MORE INFORMATION

The files that fail to register are listed here:
  • Msolap.dll

  • Msolapui.dll

  • Msmdcude.dll

  • Msmdgdrv.dll

Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbprb KB283880