?
Solved

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

Posted on 2011-03-15
3
Medium Priority
?
879 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
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…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Suggested Courses

765 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