sir this is my
jsp code this page give me right result in my browser
when am using work group not internet or local network
<HTML>
<%@ page import="java.sql.*,java.util.*" %>
<% String url="jdbc:oracle:thin:@10.0.0.237:1521:aamir";
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
con = DriverManager.getConnection(url,"muhammad","mfa786");
stmt=con.createStatement();
%>
<%
%>
<select name="ltpid">
<%
try{
rs= stmt.executeQuery("select accid,title from chartofacc");
while (rs.next()){
%>
<option Value=<%=rs.getString(1)%>> <%=rs.getString(2) %> </option>
<%
}
}
catch(Exception e){}
%>
</select>
<br>
TEST DONE!
</HTML>
***********
but when i test this page in client browser then browser give me this error
Database Log In Failed
TNS could not resolve service name
Verify that the TNS name in the connectstring entry of the DAD for this URL is valid.
i check my tnsname.ora
my sql run fine
please give me idea how i run my page in client browser
thank's
aamir
racle:thin:@<ip or hostname of machine where your db is installed>: 1521:aamir , description to connect the remote database. So, I think it's not related to your tnsname.ora problem. It's only java oracle thin connection string. Please check this string, make sure the ip and database service name is right.
