ORA-12705: Cannot access NLS data files or invalid environment specified

c# sql oracle odbc instantclient
Daniel Williams picture Daniel Williams · Jul 26, 2011 · Viewed 13.1k times · Source

I just installed the Oracle instant client on my laptop, and get this when I try to connect via ODBC in C#. The machine has had 9.2 and 10.2 installed in the past.

Why does this error appear? In my connection string, can I tell it to ignore the Oracle NLS settings?

Answer

Daniel Williams picture Daniel Williams · Jul 26, 2011

The solution was to find the registry key named NLS_LANG under:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

and rename it to anything else. I put an "x" at the end. This key is left over from a full install of Oracle. The instant client ODBC works properly now.

Related questions

How to execute an .SQL script file using c#

I'm sure this question has been answered already, however I was unable to find an answer using the search tool. Using c# I'd like to run a .sql file. The sql file contains multiple sql statements, some of which are …

Read More
problem using Oracle parameters in SELECT IN

I have a problem when inserting a string of numbers into sql query SELECT * FROM tablename a WHERE a.flokkurid IN (3857,3858,3863,3285) ORDER BY sjodategund, rodun ...or: SELECT * FROM tablename a WHERE a.flokkurid IN (:strManyNumbers) ORDER BY sjodategund, rodun ...with …

Read More
What is the syntax for an inner join in LINQ to SQL?

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join …

Read More