• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2155
  • Last Modified:

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
0
susannahbond
Asked:
susannahbond
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
0
 
schwertnerCommented:
Look the parameter NLS_LANG in the Registry of the Oracle client machines.

Also check the version and the Character set of the Oracle database.
If it is 9i or 10g possibly AL32UTF8 Unicode character set causes the error.

How to check the Char. Set of the Server (as SYS):

SELECT value FROM nls_database_parameters
WHERE parameter='NLS_CHARACTER_SET';
0
 
susannahbondAuthor Commented:
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
0
 
susannahbondAuthor Commented:
I've sorted it

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now