Re: Connection prob: ORA-12154

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 24 Jun 1999 11:38:47 +0200
Message-ID: <7ksu8q$o65$1@news3.saix.net>

huh wrote in message <7kqs7v$12va$1_at_ns.felk.cvut.cz>...

>Can someone tell me what I am doing wrong?

You're using NT and not UNIX... ;-)

>I have correct TNSNAMES.ORA file (I hope) -
>Test from "Oracle Net8 Easy Config" succeeds, however
>an attempt to connect from Enterprise Manager or MS Query using
>ODBC driver 8.00.04.00 gets an error ORA-12154.
>Network Layer is TCP/IP, server runs on NTS4.0 and client
>on NTW4.0
>Any suggestions?

Are you sure that the environment is correct? ORACLE_HOME is set, ORACLE_HOME/bin in the path (required for ODBC to work) etc.

You can also override the default path to TNSNAMES.ORA (or the network/admin folder) by using the TNS_ADMIN (or is that TNSADMIN?) environment variable.

regards,
Billy Received on Thu Jun 24 1999 - 04:38:47 CDT