Link to home
Start Free TrialLog in
Avatar of susannahbond
susannahbond

asked on

ORA-12705: invalid or unknown NLS parameter value specified

We have two XP machines connecting to an Oracle database using ODBC drivers after installing Oracle8i client
But now we have tried to connect a few more and we are getting an
 
ORA-12705: invalid or unknown NLS parameter value specified
 
It seems to be something to do with a language variable, would this be machine specific?
Any suggestions on how to fix this would be gratefully received
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of susannahbond

ASKER

Hi

I've checked the machines that work and they have NLS_LANG set as
American_america.WE8ISO8859P1

A few that don't work have either nothing installed or
American.america.WE8ISO8859P1  (a dot instead of an underscore)

Will try changing these tomorrow
I've sorted it

They have three lots of NLS_LANG and they all have to be set the same