0 Replies Latest reply: Feb 15, 2012 6:39 PM by 917823 RSS

    ODBC connection issue in EXCEL (Windows 7 64bit)

    917823
      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