Failed to get local NLS_LANG charset ID

[juned...@gmail.com]

When I tried to run an application on Win7 machines, I got "Failed to get local NLS_LANG charset ID” error.

Some information:
The application was compiled in Powerbuilder version: 11.5
Oracle Client: 11g 32 bit
Oracle database: 11.2.0.1.0 64 bits since the Server is 64bits.

I am able to connect to the Oracle database through SQLPlus,
however.

I have checked the registry, and there is only one
occurrence of NLS_LANG (found in the Oracle directory)with
the value of AMERICAN_AMERICA.WE8MSWIN1252

I have checked the environment variables, and they are:


Connected to:
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

SQL> select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
2 'NLS_LANGUAGE', 'LANGUAGE',
3 'NLS_TERRITORY', 'TERRITORY') name,
4 value from v$nls_parameters
5 WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');

NAME VALUE
------------- ----------------------------------------------------------------
LANGUAGE AMERICAN
TERRITORY AMERICA
CHARACTER SET WE8ISO8859P1

Could this be a mismatch between the language set used by the database and that used by the oracle client?

Please help!

Thanks,

June

[Bruce Armstrong [TeamSybase]]

Most of the groups shown in Google are no longer active on the Sybase server. In addition, the remaining Sybase newsgroups will be shut down shortly. If you post here most people who take the time to answer questions will never see it.

Instead, post your question in the SAP Community Network (SCN) PowerBuilder Developer Center forums:

http://scn.sap.com/community/developer-center/powerbuilder/content?filterID=content~objecttype~objecttype[thread]