Re: Help with MSADOMD in VJ++

#1

"Nathan Vu" <n_vu (AT) hotmail (DOT) com> wrote

Quote:

Hello all,

We have a web application that is a few years old that was developed with
Visual J++, Olap 2K and SQL Server 2K. It's using msadomd java package to
query/retrieve OLAP cube data.

We run into this bizarre problem that on certain Windows 2K Advanced
Server
(SP2) machines, the following method (particularly line #4):

1 static String getCellFormattedValue(msadomd.Cell cell)
2 {
3 try {
4 return cell.getFormattedValue();
5 } catch (ComFailException e) {
6 return "Error!!";
7 }
8 }

would return English-US formatted values (i.e., currency symbols, number
and
date formats, etc) even though the Control Panel->Regional Options is set
to
some locale _other than_ English-US. This call would work on other servers
with similar SP's, and the returned values are correctly formatted
correspondingly to the specified locale.

I suspect that this problem has nothing to do with VJ++. Can you please run
your query from MDX Sample and see how formatted value is formatted ?

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#2

We tried that with MDX Sample App, the data was returned correctly on all
servers.

- nv

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Quote:

"Nathan Vu" <n_vu (AT) hotmail (DOT) com> wrote in message
news:bmhtik$317v$1 (AT) news (DOT) mainstreet.net...
Hello all,

We have a web application that is a few years old that was developed
with
Visual J++, Olap 2K and SQL Server 2K. It's using msadomd java package
to
query/retrieve OLAP cube data.

We run into this bizarre problem that on certain Windows 2K Advanced
Server
(SP2) machines, the following method (particularly line #4):

1 static String getCellFormattedValue(msadomd.Cell cell)
2 {
3 try {
4 return cell.getFormattedValue();
5 } catch (ComFailException e) {
6 return "Error!!";
7 }
8 }

would return English-US formatted values (i.e., currency symbols, number
and
date formats, etc) even though the Control Panel->Regional Options is
set
to
some locale _other than_ English-US. This call would work on other
servers
with similar SP's, and the returned values are correctly formatted
correspondingly to the specified locale.

I suspect that this problem has nothing to do with VJ++. Can you please
run
your query from MDX Sample and see how formatted value is formatted ?

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#3

Quote:

We tried that with MDX Sample App, the data was returned correctly on all
servers.

Can you try to set locale explicitly in the connection string ?

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#4

Thanks for all the suggestions. The problem lies with IIS's Directory
Security-> Anonymous access and authentication control->Anonymous User edit.
The Anonymous User must be the same as the NT userid you use to log in and
change the Regional Options.

- nv

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Quote:

We tried that with MDX Sample App, the data was returned correctly on
all
servers.

Can you try to set locale explicitly in the connection string ?

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Help with MSADOMD in VJ++

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

Re: Help with MSADOMD in VJ++ - 10-14-2003 , 05:36 PM

Re: Help with MSADOMD in VJ++ - 10-14-2003 , 06:02 PM

Re: Help with MSADOMD in VJ++ - 10-14-2003 , 06:44 PM

Re: Help with MSADOMD in VJ++ - 10-15-2003 , 05:34 PM