FIX: Error When Regional Setting Is Different Than Operating System Language (298701)

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.

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.