Solved

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

Posted on 2011-03-15
3
862 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:khuehne
  • 2
3 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35138789
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
 

Author Comment

by:khuehne
ID: 35243601
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
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 35243741
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

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question