Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC & Oracle9i

Re: ODBC & Oracle9i

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 26 Jan 2002 13:47:34 GMT
Message-ID: <Wry48.5549$Om2.17352@rwcrnsc53>


Try using sqlplus. Login with sqlplus and use NHEMS. If that does not work try NHEMS.world and see if that works. Asl try putting nothing in. I am assuming sine this is a nonnetworked environment that you are trying to do this on the same machine the database is on. Jim
"William O'Neill" <wfoneill_at_mindspring.com> wrote in message news:a2tdb8$fp5$1_at_slb7.atl.mindspring.net...
> Using Oracle 9i(Enterprise) on WIN2K, in a non-networked environment.
Have
> installed same on my home computer to assist me with learning this new
> version of Oracle.
> For the life of me, I cannot establish a ODBC connection to my DB. The
> listerner is 'listening,' and my TNSNAMES.ora file seems to be fine, since
I
> can connect to the DB, but when trying to establish an ODBC profile, I get
> the dreaded msg ORA - 12154: TNS: could not resolve service name. My SID
in
> TNSNAMES.ora is NHEMS, and so in the ODBC profile I put NHEMS in the TNS
> Service Name block. Any suggestions?
> Also, is the Client for Oracle 9i an application like SQL*Net used to be
for
> Oracle 7/8. If so, I can't find it. Any ideas here???
>
>
Received on Sat Jan 26 2002 - 07:47:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US