Connection Problem MS Access with Tomcat

[sridhar Ranganathan]

Hi,

I try connect MS Access with Tomcat using jsp.
I cant able to get output.Same program i written in Java,
Its running.But there is problem in Jsp.Kindly tell me suggestion.

<%
        Statement stmt;
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.println("Output----------1");
 
}
catch(ClassNotFoundException e)
{
out.println(e);
}
try
{
con = DriverManager.getConnection("jdbc:odbc:dsn");
out.println("Output----------2");
stmt = con.createStatement();
String s1 = "insert into student values(1111,'rahul')";
stmt.executeUpdate(s1);
 
}
catch(SQLException e)
{
out.println(e);
}
 
%>

output:
Output----------1.




[BSouther: Added UBB CODE tags]
[ February 15, 2008: Message edited by: Ben Souther ]

[David O'Meara]

What does the exception say?

[Bear Bibeault]

Please be sure to use UBB code tags when posting code to the forums. Unformatted code is extermely hard to read and many people that might be able to help you will just move along. Please read this for more information.

You can go back and change your post to add code tags by clicking the .