I'm having problems connecting to extenal database using Oracle ODBC driver for Windows 7 32bit .
I have downloaded the instantclient odbc nt 188.8.131.52zip 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.