Hi,
This jsp code doesn't run. Why ?
-----------------------------------------------------------
<%@ page import="java.sql.*" %>
<%!
String Query(String SQL, String DSN)
{
ResultSet rs;
Statement stmt;
String App = "";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:"+"DNS");
stmt = conn.createStatement();
//......
stmt.close();
return App;
}
catch (Exception e)
{
return e.toString();
}
}
%>
<HTML>
<BODY>
<%= Query("select * from table","DNS") %>
</BODY>
</HTML>
-------------------------------------------------------------------
Tomcat show me this error:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
Can I resolve this problem in tomcat ?
I use Tomcat 5.5 and jdk1.5.0_01.
The pure java code is ok and i can connect to the database.
Thanks in advance.
Rik