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

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.
khuehneAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I'm not sure what an ifile pointer is.  Just for testing right now, try a local copy.  If that works then there is a problem using an ifile with Oracle.
0
 
slightwv (䄆 Netminder) Commented:
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.
0
 
khuehneAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.