JDBC连接SQL SERVER问题!
如何连啊
我按文档所说的连不成功啊.
先安装JDBC FOR SQLSERVER2000,安装成功,然后设置环境变量CLASSPATH:
.;C:\j2sdk1.4.2_06\lib\tools.jar;C:\j2sdk1.4.2_06\lib\dt.jar;C:\j2sdk1.4.2_06\lib\Conn.class;C:\SQLServer2000DriverforJDBC\lib\mssqlserver.jar;C:\SQLServer2000DriverforJDBC\lib\msbase.jar;C:\SQLServer2000DriverforJDBC\lib\msutil.jar
接着在JSP程序里:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page language="java" %>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<%@ page import = "java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import = "java.lang.*"%>
<%
Connection conn=null;
ResultSet rs=null;
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr ="jdbc:microsoft:sqlserver://210.72.44.219:1433,DatabaseName=jmtj,user=sa,password=";
Class.forName(sDBDriver);
conn= DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();%>
结果显示找不到类异常:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
哪里有问题啊,我的操作系统是2003