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

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 Wed Jun 25 2003 - 23:20:22 CEST