Re: ODBC problem with Oracle

hi all,

it's TNS_ADMIN. On NT/2000 you have to ake a new entry inside the registry.

If you habe only 8.0.x on your client, put it under HKEY_LOCAL_MACHIENE\SOFTWARE\ORACLE.

If you habe 8.1.x on your client, put it under each HKEY_LOCAL_MACHIENE\SOFTWARE\ORACLE\HOMEn. (?)

Let the entries point to the directory, where SQLNET.ORA and TNSNAMES.ORA reside.

That way, you can use multiple ORA_HOMEs while maintaining only one TNSNAMES.ORA. greeting
Marc

On 7 Oct 2001 01:35:32 -0700, faheemrao_at_yahoo.com (FaheemRao) wrote:
> 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 Tue Oct 09 2001 - 04:01:32 CDT