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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi
I've checked the machines that work and they have NLS_LANG set as
American_america.WE8ISO885 9P1
A few that don't work have either nothing installed or
American.america.WE8ISO885 9P1 (a dot instead of an underscore)
Will try changing these tomorrow
I've checked the machines that work and they have NLS_LANG set as
American_america.WE8ISO885
A few that don't work have either nothing installed or
American.america.WE8ISO885
Will try changing these tomorrow
ASKER
I've sorted it
They have three lots of NLS_LANG and they all have to be set the same
They have three lots of NLS_LANG and they all have to be set the same
https://www.experts-exchange.com/questions/21065862/ORA-12705-Invalid-or-unknown-NLS-parameter-value-specified.html