Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database Archived Forums
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 15, 2012 6:39 PM by
ODBC connection issue in EXCEL (Windows 7 64bit)
Feb 15, 2012 6:39 PM
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 : 220.127.116.11.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
This content has been marked as final.
Show 0 replies