Re: ODBC problem with Oracle

From: Peter Laursen <pl_at_mail1.remove.this.stofanet.dk>
Date: Sat, 6 Oct 2001 16:38:56 +0200
Message-ID: <3bbf187f$0$14817$ba624c82@nntp02.dk.telia.net>

"George" <divined2000_at_hotmail.com> wrote in message news:e480c22a.0110060609.359b0330_at_posting.google.com...
> I`m trying to restore a database which was created using
Oracle. under
> Oracle 8.0.5. The Oracle Easy net8 config assistant
completes with no
> error and the connection returns successfully. However
when I try to
> connect using Oracle ODBC Test, I get the following
message :
>
> SQLState:08004
> Native Error Code:12154
> Driver Message:[Oracle][ODBC][ORA]ORA-12154: TNS: could
not resolve
> service name.
>
> I have set the System DNS to connect to my database with
the
> appropriate SID. How could the net8 easy config be able to
find the
> service using both TCP/IP and IPC but the ODBC test fails?
Any help
> would be appreciated.

George,
Dont put the SID in the DNS. Put the servicename there. The servicename is then resolved using the tnsnames.ora file.

/Peter Received on Sat Oct 06 2001 - 09:38:56 CDT