11 Replies Latest reply: Jun 20, 2014 1:46 PM by M.R. RSS

    ORA-12154 Windows 7 32bit ORACLE 11g ODBC Driver CONNECT


      Hi All,




      I'm having problems connecting to extenal database using Oracle ODBC driver for Windows 7 32bit  .


      I have downloaded the instantclient odbc nt drivers for 32-bit and unpacked it

      and run the installer and choose the default location ie c:\app\product\11.2.0\client_1



      2.I done all the necessary setting ie set the Path and creating new user variable for tns admin

      in the system environment and modified the hostfile on etc sys32 and copied both tsnamesn and sqlnet

      to Network\Admin file


      3.I then started the Data Sources (ODBC) manager, configured the driver and tested the

      configuration then I got a testing connection error SQLstate= 08004... ORA-12154 TNS couldn't connect.

      could you please help. Thanks in advance.