Hi guys, I have a web application developed in Visual Studio 2008, framework 2.0, having oracle database at backend. When I tries to run the applicatoin on Visual Studio I got following error:
RA-12154: TNS:could not resolve service name
Initially I thought it's TNS issue, however ; later I deployed it to IIS and it stat running perfectly. The reason I did this is because this applicatioin was running on another PC perfectly.
Can some body tell me what am I missing. any help in this regards would be heighly appreaiaty.
Javeed M ShaikhPosted Nov 3, 2011, 9:23 AM
can you please post the entries from your SQLNET.ORA file.
ali razaPosted Nov 3, 2011, 12:35 AM
Hi javaid, I run the command you mentioned and got following output. I think this is not the issue with TNS path this is the issue with user rights because when I run the same project in IIS (means deploy web site to iis) it starts working fine the problem it is visual studio is not able to access TNS.
TNS Ping Utility for 64-bit Windows: Version 10.2.0.1.0 - Production on 03-NOV-2
011 09:24:14
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
E:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
38.103)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = porta
l)))
OK (10 msec)
Javeed M ShaikhPosted Nov 2, 2011, 9:00 AM
Please go to the command prompt of the machine where this is not working and type the following:
tnsping
check the output and let us know.