GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
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 4:39 PM by 917823
ODBC connection issue in EXCEL (Windows 7 64bit)
Feb 15, 2012 4:39 PM
Currently Being Moderated
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
Track in Communications
- 10 points
- 5 points