Re: ORA-12154: TNS: could not resolve service name..when using hsodbc

Hi there,
Obviously no..tnsnames.ora on the Oracle end is configured properly. but i still get that error

Any clue,
avsrk

"TC" <donotuse_at_donotuse.com> wrote in message news:<qmoKa.18840$3d.12014_at_sccrnsc02>...
> Remote mysql database using tnsnames.ora ?
>
> Or am I missing something over here ?
>
> //tc
>
>
>
> "Subrahmanyam Arya" <avsrk_at_mailcity.com> wrote in message
> news:25c1993e.0306250719.2cacd61a_at_posting.google.com...
> > Dear oracle gurus,
> >
> > I am unable to get past the error ORA-12154: TNS: could not resolve
> > service name on my host when using hsodbc to talk to a remote mysql
> > database. i got from the meta link all the needed documenatation to
> > configure inithsodbc.ora,listener.ora,tnsnames.ora and related errors
> > Here is what it says
> >
> > ORA-12154:
> > SQL> select * from all_catalog_at_demo;
> > select * from all_catalog_at_demo
> > *
> > ERROR at line 1:
> > ORA-12154: TNS:could not resolve service name
> >
> > Resolution:
> > The database link uses a SQL*Net alias not specified
> > in the TNSNAMES.ORA of the database server.
> > Query the data dictionary to figure out the 'HOST'
> > specified for the database link:
> > select db_link, host from user_db_links;
> > or
> > select db_link, host from dba_db_links;
> > The 'HOST' value is the alias of the SQL*Net.
> > Please make sure it exists in the TNSNAMES.ORA file
> > present at the Oracle database server.
> >
> > I did this query and the host value and SQL*Net alias match.
> > I dont know what is that i am missing
> >
> > Your help is greatly appreciated.
> >
> > -thanks,
> > avsrk
Received on Thu Jun 26 2003 - 15:24:17 CEST