1. Olivier THEVENIOT
  2. PowerServer Web
  3. Thursday, 08 November 2018

Hello,

I have a problem between PowerServer Web and Oracle. The decimal values ​​are multiplied by 100. I suspect a decimal separator problem.

How can i define it ?

It works well in PowerBuilder.

Thank you

Olivier

Zhao Kai Accepted Answer Pending Moderation
0
Votes
Undo

Hi Olivier,

What's the Oracle database version you are using? and what’s the Oracle client
version you are using?

And please note that, for Oracle database, the NLS_LANG on the machine where
the Appeon server located at should be the same with the one on the database
server. So please go to the Register on the server where the Appeon server is
installed to check if the NLS_LANG in the directory:
HKEY_LOCAL_MACHINE>SOFTWARE>ORICAL( or
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE) is the same with the one in
database. Change it to make it be the same as the one on the server side if
they are different and restart IIS Server.

Regards,
ZhaoKai

Comment
Hi Zhao,

Thanks for your answer.

NLS_LANG was the same in Appeon server and in Oracle server.

And it works very well with PowerBuilder version started on Appeon server.

There are two parameters called 'Other Options' and 'Extended Options' in Data Source configuration of PowerServer. But i don't know how to fill them.

Regards,

Olivier

  1. Olivier THEVENIOT
  2. Friday, 9 November 2018
There are no comments made yet.
  1. Friday, 9 November 2018
  2. PowerServer Web
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.