The Pick List for the TNS Service Name Property Shows Junk/Garbage Characters When Accessed During the Configuration of an ODBC DSN

(Doc ID 882357.1)

Last updated on JANUARY 03, 2014

Applies to:

Oracle ODBC Driver - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Generic Windows
***Checked for relevance on 03-Jan-2014***

Symptoms

You are using Instant Client ODBC Driver or Full Client ODBC Driver and getting garbled / junk / corrupt characters in drop down list for TNS Service name. You have set TNS_ADMIN in the registry to your ORACLE_HOME path where your tnsnames.ora resides.

Another possible reason for encountering the garbage / junk characters is as follows:

If you have not set TNS_ADMIN in the registry but instead as an environment variable and still see this problem then you may have a tnsnames.ora file with an appended .txt extension that may not be realized.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms