java连接sql2000

将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();

          }