jsp连接sqlserver2005时报以下错误该怎么处理

[chiyan_2011]

java.lang.ClassNotFoundException: com.microsoft.jdbc.odbc.SQLServerDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:48)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:619)

[小幺鸡]

右键点击工程项目，build path-->add external导入sqljdbc4.jar
我很怀疑LZ的结帖率

[代号裤子]

没找到驱动

[shenhua]

sqlserver2005.jar包有导入？

[jerrylau120]

sqlserver的odbc的包没导入

[oubo824219]

。。。。。。。。。同上

[涵笑情川]

驱动问题

[涵笑情川]

还有就可能是sql 没升级的原因

[空心兜兜]

木有相应的JAR包

[wnf2009]

没家堡

[chiyan_2011]

我确定我导入包了！

<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312"%>
<%
try{
Class.forName("com.microsoft.jdbc.odbc.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db";
String user="sa";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();

String sql="select * from t2";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
第一个字段的内容是：<%=rs.getString(1) %>
第二个字段的内容是：<%=rs.getString(2) %>
<br>
<% }%>
<% rs.close();
stmt.close();
conn.close();
}catch (Exception e) {
e.printStackTrace();
};
%>
大家看看我的代码有没有什么不对的地方！还有在连接时对数据库的配置有哪些要求？？如果有怎么设置？

[chiyan_2011]

[Quote=引用 4 楼 b1481263728 的回复:]

右键点击工程项目，build path-->add external导入sqljdbc4.jar
我很怀疑LZ的结帖率
[/Quote]
你确定是这个包？我试过了也不行啊!

[Canace_lemon]

jar包的版本不对！！ 或者你将jar包扔进去lib目录里面去

[juesha890519]

控制面板下面 odbc数据源里面设置数据源

[半个鼠标]

没架包，或者架包不跟数据库的版本对应！

[半个鼠标]

还有或者jar包放错地方了，在web项目中应该放在WEB-INF下的lib目录中

[chiyan_2011]

谢谢各位前辈指导!连上了,我把sqlserver重装了一下就成了!