Microsoft KB Archive/919427

= You cannot use can the MSOLAP provider name to reference the Analysis Services 9.0 OLE DB Provider after you install or repair an Office 2003 program =

Article ID: 919427

Article Last Modified on 7/26/2006

-

APPLIES TO


 * Microsoft Office Professional Edition 2003
 * Microsoft Office Small Business Edition 2003
 * Microsoft Office Access 2003
 * Microsoft Office Excel 2003

-





SYMPTOMS
Consider the following scenario. You install Microsoft SQL Server 2005 Analysis Services on the computer. Then, you install or repair one of the programs that are listed in the &quot;Applies to&quot; section. In this scenario, you cannot use the MSOLAP provider name to reference the Analysis Services 9.0 OLE DB Provider.



CAUSE
This problem occurs because the Office 2003 Setup program installs the older PivotTable Service. This older PivotTable Service overwrites the version-independent ProgID attribute.



How to obtain the hotfix
This issue is fixed in the Office 2003 post-Service Pack 2 Hotfix Package that is dated April 24, 2006. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

913646 Description of the Office 2003 post-Service Pack 2 hotfix package: April 24, 2006



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information about this problem, see the Analysis Services 9.0 OLE DB Provider May Be Overwritten By Client Applications topic in section 4.2.3 of the following article in the Microsoft Knowledge Base:

910228 SQL Server 2005 Readme and installation requirements

Additional query words: office2003 office2k3 office11 off2003 off2k3 off11 access2003 access2k3 access11 acc2003 acc2k3 acc11 excel2003 excel2k3 excel11 xl2003 xl2k3 xl11

Keywords: kbexpertiseinter kbdatabase kbhotfixserver kbpubtypekc kboffice2003presp3fix kbbug kbfix kbqfe kbprb KB919427

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.