Locale Identifier

[SonOfXavier]

Has anyone used the "Locale Identifier" in the Pivot Table connection string
successfully? If so, did you have any problems doing so? Did you have to
install any new DLLs?

I have tried the following and it doesn't work:

pt.connectionstring = "Provider=MSOLAP.2;Data Source=MyDataSource;Initial
Catalog=Database;Client Cache Size=25;Auto Synch Period=1000; Locale
Identifier=1036;"

This should return the OWC Pivot Table with the Captions set to French.

Before you ask, I have tested this connection string with another object
(ADODB/ADOMD) on the same cube and that object returns the correct
information.

Thanks Gord

 

[CUBBI]

You should use:

; Extended Properties="LocaleIdentifier=1036" ;