Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Technology Network Community (OTN)
Oracle Database Archived Forums
This discussion is archived
on Feb 16, 2012 12:39 AM by 917823
ODBC connection issue in EXCEL (Windows 7 64bit)
Feb 16, 2012 12:39 AM
Hi , I encounter a strange issue with Oracle ODBC driver
When I retreive data with ODBC driver in EXCEL , if I first open excel and then in the MENU , choose Open , and then select
the excel file from Windows Explorer , then can successfully retrieve data .
But if I double the Excel file directly , and then retreive data , I got the below error :
ORA-12154: TNS: could not resolve then connect identifier specified
and also test connection in System DNS's ODBC configuration , no problem.
Any idea ? thanks in advance.
My OS version : Windows 7 Professional SP1 64bit
Oracle Instant Client version : 126.96.36.199.0 (32bit)
Excel version : EXCEL 2007 Professional (32bit)
OraCLE DATABASE VERSION : 10.2.0.3.0 (64bit)
environment variable "PATH" include :
and variable "TNS_ADMIN" set as C:\instantclient as well.
tnsnames.ora in the path c:\instantclient
I have the same question
Show 0 Likes
This content has been marked as final.
Show 0 replies