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 NOVEMBER 15, 2011

Applies to:

Oracle ODBC Driver - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

In the sqlnet.ora there is: NAMES.DEFAULT_DOMAIN = xx.domain.com

In the TNSnames.ora there are entries from other domains such as: orcl.xx.someotherdomain.com =
(DESCRIPTION =
(ADDRESS_LIST =...

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.

Cause

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
  Symptoms
  Cause
  Solution
  References

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