Re: ODBC problem with Oracle

How many Oracle home you have ?

If you have multiple homes then you have to set an enviornment varaible that which tnsnames.ora file is to be used .

I dont remember the name of that enviornment varaivble. So you can go to technet and search for that varaible , it is TNS_ something
and you have to set that enviorment varaible equal to the folder name which contain the correct tnanames.ora file. for example
Enviornment_variable = oracle_home\ora81\network\admin

But to do a quick fix try to put that service name to all of the Tnanames.ora file you have.

"Christian Stelte" <zlk_at_gmx.net> wrote in message news:<9pn6ql$ku3$02$1_at_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 Sun Oct 07 2001 - 03:35:32 CDT