<div>
The tnsnames.ora file needs to be in a specific directory (ORACLE_HOME/netwrok/admin<wbr />) or you need to set a TNS_ADMIN environment variable to the folder where it resides.
</div>


The tnsnames.ora file needs to be in a specific directory (ORACLE_HOME/netwrok/admin) or you need to set a TNS_ADMIN environment variable to the folder where it resides.

<div>
The tnsnames file is in the ORACLE_HOME/network/admin folder and I also tried setting the TNS_ADMIN environment variable and got the same outcome.
</div>


The tnsnames file is in the ORACLE_HOME/network/admin folder and I also tried setting the TNS_ADMIN environment variable and got the same outcome.

<div>
<div class="content wysiwyg-content">
I installed the Oracle 10g ODBC driver on a Windows 7 32-bit computer and this driver fails if I'm not logged on as administrator. &nbsp;The error code is ora-12154 &nbsp;TNS:could not resolve the connect identifier specified. &nbsp;I am using an ifile pointer to a network tnsnames.ora file. &nbsp;The other account that I'm using to test is an administrator on the computer, but it still fails.
</div>
</div>


I installed the Oracle 10g ODBC driver on a Windows 7 32-bit computer and this driver fails if I'm not logged on as administrator.  The error code is ora-12154  TNS:could not resolve the connect identifier specified.  I am using an ifile pointer to a network tnsnames.ora file.  The other account that I'm using to test is an administrator on the computer, but it still fails.

Oracle 10g ODBC driver fails on Windows 7 except when logged in as administrator

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.