| TNS:could not resolve service name [message #168685] |
Fri, 21 April 2006 11:09  |
rranjan
Messages: 3
Registered: April 2006
Location: Edision
|
Junior Member |
|
|
Hi all,
I am etting following error when I tries to connect thr my oracle datanase from my machine. I have the entry in my tns file.
Second thing I m able to connect oracle thr oracle client.
I am also able to connect Oracle when I put the same code on a button click, But when I m ying to make it web-service, It gives the following error.
Please suggest,
Rakesh
ERROR :
===========================
System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve service name
|
|
|
|
| Re: TNS:could not resolve service name [message #169093 is a reply to message #168685] |
Tue, 25 April 2006 01:06  |
zeshanali76
Messages: 180
Registered: January 2006
Location: Pakistan
|
Senior Member |
|
|
first of all check that which tnsnames.ora file is used for redirecting with command
tnsping <alias_name>
It will show a file path of tnsname.ora/sqlnet.ora file like
$ORACLE_HOME/ora92/network/admin
so u have to create alias in this tnsnames.ora file. then u can connect ur desire destination.
Zeeshan Ali AWan
zesh76@msn.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
