Microsoft KB Archive/298701

= FIX: Error When Regional Setting Is Different Than Operating System Language =

Article ID: 298701

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q298701



BUG #: 11561 (Plato7.x)



SYMPTOMS
When an Analysis Services client application that uses Pivot Table Services runs on a localized operating system with the regional setting set to a different language, the following error may be seen from the Office Web Component Pivot Table control:

Query Could not be Processed.



CAUSE
The resource DLLs (which have a .rll extension) cannot be found for the specified language, and the resource DLLs for English are not installed.



RESOLUTION
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
There are two ways to work around this problem:
 * Install the Analysis Services client, which is called Pivot Table Services, after the installation of Microsoft Office. This will always install the needed English resource DLLs. You can do this in either of two ways:
 * Run the setup program from the SQL Server 2000 CD and choose just the client components for Analysis Services.
 * Execute the Ptsfull.exe program, which is located on the SQL Server 2000 CD in the MSOLAP\Install\PTS folder.
 * Manually create the folder C:\Program Files\Common Files\System\OLE DB\resources\1033 and place the resource DLLs for your language in the newly created folder. The files that you want to move to the folder are Msdmine.rll, Msolap80.rll, and Olapuir.rll.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.



MORE INFORMATION
By default, the Analysis Services client (in other words, the Office Web Component) installs the resource DLLs for the language of the localized version of the Windows operating system. However, if the regional setting is different than the language of the localized version of the operating system, the resource DLLs for the regional setting are not installed by the Analysis Services client.

When the Analysis Services client looks for the resource files for the specified language and cannot find them, it then attempts to load the English resource DLLs located in the C:\Program Files\Common Files\System\OLE DB\resources\1033 folder. If the English resource files cannot be located, the error shown above is displayed when the OLE DB provider for OLAP attempts to load.

Additional query words: OLAP Query Could not be Processed.

Keywords: kbbug kbfix kbssas800sp1fix KB298701

-

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

© Microsoft Corporation. All rights reserved.