Re: ODBC problem with Oracle

From: Christian Stelte <zlk_at_gmx.net>
Date: Sat, 6 Oct 2001 17:08:23 +0200
Message-ID: <9pn6ql$ku3$02$1@news.t-online.com>

Hi!

It also helps, to put the service name into the local hosts file. Try a ping on the service name.

Chris

"Peter Laursen" <pl_at_mail1.remove.this.stofanet.dk> schrieb im Newsbeitrag news:3bbf187f$0$14817$ba624c82_at_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 - 10:08:23 CDT