Solved

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

Posted on 2011-03-15
3
860 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 76

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 76

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.

773 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