The Pick List for the TNS Service Name Property Shows Junk/Garbage Characters When Accessed During the Configuration of an ODBC DSN
Last updated on JANUARY 03, 2014
Applies to:Oracle ODBC Driver - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 11.2]
***Checked for relevance on 03-Jan-2014***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms