将sql2000升级至sp4 。下载jdbc sp3,将bin下的三个jar文件加入CLASSPATH;
测试码如下:
import java.sql.*;
public class SqlTest{
public static void main(String[] args){
String host="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
try{
Class.forName("com.Microsoft.jdbc.sqlserver.SQLServerDriver");
Connection dbCon=DriverManager.getConnection(host,"sa","");
System.out.println("Connected");
}catch(Exception e){
e.printStackTrace();
}