My Oracle Support Banner

Oracle ODBC Driver Configuration: Net Service Name Drop Down List Is Not Fully Qualified (Doc ID 1338088.1)

Last updated on MARCH 04, 2022

Applies to:

Oracle ODBC Driver - Version and later
Information in this document applies to any platform.


In the sqlnet.ora there is: NAMES.DEFAULT_DOMAIN = <domain name>

In the TNSnames.ora there are entries from other domains such as: <some other domain name> =

When an ODBC DSN is configured however, the drop down list box for TNS service names has only the first segment of the entry name that gets populated.

In this case, ORCL would be used. This results in a service not found error since the drop down box does not offer the entire fully qualified entry.


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

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