jdbc and SQLServer
I am trying to connect to a SQLServer database from my servlet using jdbc connectivity. I am able to connect to the db if I create a datasource. but if I try to make a connection by giving the connection string (DriverManager.getConnection(..)), I am getting an SQLException "No driver found" at Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver). I tried registering the driver using DriverManager.registerDriver(...) command, then I get NoClassDefFound error. I think it is a problem related to ClassLoader. I can see the deployed driver files in VA under the ClassLoader Viewer. Any idea what's going on here.