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)

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.