This discussion is archived
0 Replies Latest reply: Feb 15, 2012 4:39 PM by 917823 RSS

ODBC connection issue in EXCEL (Windows 7 64bit)

917823 Newbie
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 : 11.2.0.2.0 (32bit)
Excel version : EXCEL 2007 Professional (32bit)
OraCLE DATABASE VERSION : 10.2.0.3.0 (64bit)


environment variable "PATH" include :
c:\instantclient

and variable "TNS_ADMIN" set as C:\instantclient as well.

tnsnames.ora in the path c:\instantclient

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points