6 Replies Latest reply on Feb 8, 2011 11:20 AM by Gaillimh

    Instant client with ODBC driver

      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.
      here is the contents of tnsname.ora:
      # TNSNAMES.ORA Network Configuration File: c:\oracle8i\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

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

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