Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

NLS_LANG error when trying to connect to the database

1,667 views
Skip to first unread message

lisal

unread,
Jan 22, 2010, 11:38:17 AM1/22/10
to
In Powerbuilder Database Profile, when I try to connect to
the Oracle database, I get this error message: Failed to get
local NLS_LANG Charset ID.
This is happening on my new laptop, where I just installed
Powerbuilder and Oracle Client.

Some information:
Powerbuilder version: 10.5.2
Oracle Client: 11.1.0.7
Connect from Powerbuilder to the Oracle database using
Oracle 10g driver
On the database Profile, System tab, the NLS Charset is set
to Unicode
I am able to connect to the Oracle database through Toad,
however.

I have uninstalled and re-installed both Oracle Client and
Powerbuilder (and reboot the machine), but I am still
getting the same error.

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 there is no
occurrence of NLS_LANG there.

Please help!

Thanks.

Terry Dykstra [TeamSybase]

unread,
Jan 22, 2010, 1:27:56 PM1/22/10
to
Are you using 64-bit Oracle client? If yes, you'll have to install the
32-bit client.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Lisa L> wrote in message news:4b59d479.1da...@sybase.com...

lisal

unread,
Jan 25, 2010, 9:53:41 AM1/25/10
to
Terry, thank you for your response.
I was already using 32-bit client.


I have resolved the issue by installing the version 10 of
Oracle client (I had only version 11 of Oracle client
installed before).


> Are you using 64-bit Oracle client? If yes, you'll have
> to install the 32-bit client.
>
> --
> Terry Dykstra (TeamSybase)
> http://powerbuilder.codeXchange.sybase.com/
> http://casexpress.sybase.com
> product enhancement requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> <Lisa L> wrote in message
> > news:4b59d479.1da...@sybase.com... In
> > Powerbuilder Database Profile, when I try to connect to
> the Oracle database, I get this error message: Failed to
> > get local NLS_LANG Charset ID.
> > This is happening on my new laptop, where I just
> > installed Powerbuilder and Oracle Client.
> >
> > Some information:
> > Powerbuilder version: 10.5.2
> > Oracle Client: 11.1.0.7
> > Connect from Powerbuilder to the Oracle database using
> > Oracle 10g driver
> > On the database Profile, System tab, the NLS Charset is
> > set to Unicode
> > I am able to connect to the Oracle database through Toad

> > , however.

Terry Dykstra [TeamSybase]

unread,
Jan 25, 2010, 11:00:09 AM1/25/10
to
Shouldn't have to do that. I use 11g client and I have no problem
connecting from 11.5 / 12.0 beta.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Lisa L> wrote in message news:4b5db075.182...@sybase.com...

0 new messages