连接sql server2000 提示No suitable driver错误？这是什么原因？？

[易点互联]

server.xml的配置如下：
<Context path="/TESTJsp" docbase="/TESTJsp" workdir="TESTJsp/j2src" debug="0" reloadable="true">
<Resource name="jdbc/sample_db" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/sample_db">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>123</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=pubs;</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context>
web.xml配置如下：
<resource-ref>
<description>jndi by libo</description>
<res-ref-name>jdbc/sample_db</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
jsp文件如下：
<%
Connection con = null;
Statement stmt1 = null;
ResultSet rs = null;

request.setCharacterEncoding("GB2312");

String employee_id = null;
String last_name = request.getParameter("last_name");
String first_name = request.getParameter("first_name");

String new_last_name = "";
String new_first_name = "";

<%
try
{
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/sample_db");
con = ds.getConnection();

stmt1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM employee";
rs = stmt1.executeQuery(query);

rs.last( );
new_last_name = rs.getString("lname");
new_first_name = rs.getString("fname");

}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
finally
{
try {
if(con != null)
{
con.close();
}
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
}
%>
提示错误：
sqle=org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL 'jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=pubs;', cause: No suitable driver

好像都没错阿。这是为什么

[laoyuan0032]

需要把SQLServer 2000 Driver for JDBC 安装一下，然后把LIB 文件夹下的三个文件拷贝到 web容器的lib下。试一下

[simon810610]

你设的classpath里包含了jdbc驱动了吗?

[ymm]

没加全包

[shangqiao]

'jdbc:microsoft: sqlserver://localhost:1433;DatabaseName=pubs写错了，假如真是这么写的，不好意思，sqlserver前面多了一个空格

[易点互联]

真是这样的
谢谢