Hi SDN,
I am trying to connect to sqlServer2005 using the following code
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = java.sql.DriverManager.getConnection("jdbc:sqlserver://obtdev15:1433;DatabaseName=O50");
response.write("connection succeded<br>");
Statement st= con.createStatement();
response.write("statement created<br>");
ResultSet c = st.executeQuery("select * from [SAPO50DB].[OGP_PROJECT]");
response.write(" rows selected-->" + c.getString("PROJECTNAME"));
}catch(Exception e){
e.printStackTrace();
response.write("exception in --"+e);
}
}
}
when i execute it, it throws the following exception
<b>java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver Found in negative cache -
Loader Info -
ClassLoader name: [com.sapportals.portal.prt.util.ApplicationClassLoader@b460e20] Parent loader name: [com.sapportals.portal.prt.util.AutoClassLoader@a52a72a] References: not registered! Resources: F:\usr\sap\O50\DVEBMGS50\j2ee\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\WEB-INF\portal\portalapps\ConnectingtoDB\lib\api.jar -
</b>
Please suggest me to rectify the above error.
your help will be awarded.
Thanks in Advance.
Regards
Basha