Skip to Main Content

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

2682152May 28 2014 — edited Jun 20 2014

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.

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jul 18 2014
Added on May 28 2014