dbTalk Databases Forums  

Can't set Locale Identifier through Analysis Services UI

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Can't set Locale Identifier through Analysis Services UI in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jonathan Levine
 
Posts: n/a

Default Can't set Locale Identifier through Analysis Services UI - 06-01-2004 , 05:43 AM






I'm connecting an Analysis Services Server running on an Windows 2003
(locale ID 1033) machine to an SQL Server containing Japanese data.

The default connection is in Locale ID 1033, which unfortunately
munges the Japanese. So I want to change the Locale ID to 1041.

I've observed the following when trying to do this via the UI

1. Right Click the data source
2. Select Edit...
3. Select the All tab
4. Select Locale Identifier
5. Select Edit Value...
6. Change the value to 1041
7. OK out of the dialogs
8. Select Edit...
9. Select the All tab

OBSERVE: the Locale Identifier is set back to 1033. And the Japanese
is still munged.

If I go directly into the repository database (in an SQL Server
database) and directly change the connection string to include Locale
Identifier=1041, then restart the server, the Japanese appears OK.
But if I go back to Data Source/Edit.../All, the Locale Identifier is
still displaying as 1033.

Is this a bug?

Thanks,

Jonathan

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.