6 Replies Latest reply: Feb 8, 2011 5:20 AM by Gaillimh RSS

    Instant client with ODBC driver

    521548
      Hi, I have problem with the instant client version 10.2 with ODBC driver. I have the instant client base package and ODBC package installed in my computer. the Oracle ODBC driver did appear in the ODBC driver list, when I test the connection with driver, it gives error "Unable to connect, SQLState=08004 [ORACLE] [ODBC] ORA-12154 TNS could not resolve the connect identifier specified" I have another computer which has Oracle 8i client installed and works fine. I copied sqlnet.ora and tnsnames.ora to the instantclient installation folder, same error appears. here is the contents of sqlnet.ora:
      # SQLNET.ORA Network Configuration File: c:\oracle8i\network\admin\sqlnet.ora
      # Generated by Oracle configuration tools.
      SQLNET.AUTHENTICATION_SERVICES= (NTS)
      NAMES.DIRECTORY_PATH= (TNSNAMES)
      here is the contents of tnsname.ora:
      # TNSNAMES.ORA Network Configuration File: c:\oracle8i\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      barkeep =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SID = barkeep)
      )
      )

      I test the host connection with telnet, it works.
      can anybody out there walk me through how to set up instant client?
      thanks.