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 FEBRUARY 27, 2019
Applies to:Oracle ODBC Driver - Version 10.2.0.1 to 184.108.40.206 [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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document