Using a Mapped Network Drive on Vista / Windows 7 Fails With ORA-12154 (Doc ID 563432.1)

Last updated on JULY 07, 2017

Applies to:

Oracle ODBC Driver - Version 10.2.0.5 and later
Microsoft Windows (32-bit)

*** Checked for relevance on 07-Jul-2017 ***


Symptoms

This article applies to specific Windows versions - see above.

When trying to connect using the test connection button in the dsn configuration in the ODBC administrator fails with error:
ORA-12154 TNS: COULD NOT RESOLVE THE CONNECT IDENTIFIED SPECIFIED

TNS_ADMIN is set to use a tnsnames.ora on a mapped network drive, for example K:\.

Works if tnsnames.ora is placed in local network\admin directory or any other local directory. SQL*Plus connection connects.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms