java.sql.SQLException: No suitable driver
I know you've all seen this one before, but I cannot figure it out.
I added the rt.jar to my libraries folder, my classpath and my WAS 5.1 servers classpath and java path and I still cannot connect.
String url = "jdbc:odbc:ITV";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url, "web_user", "web_user");
Statement stmt = conn.createStatement();
[431 byte] By [
kmcnea] at [2007-11-27 9:01:39]

# 2
I'm using Sql Server, I have also tried to hit Access. The weird thing, is that I can connect just fine with a straight Java class using the EXACT same code and running it thru the debugger. It's only when I run a jsp file in the test server that it gives that error. So, I know the connection string and code is correct, it's some classpath problem with WAS 5.1.
kmcnea at 2007-7-12 21:31:29 >
