JBuilder 2006 連接 SQL Server 2000 完整環境設定與除錯實錄

環境

JDK 1.5 + JBuilder 2006 + SQL Server 2000 SP3

JDBC 驅動安裝與 CLASSPATH 設定

1. 微軟官網下載 SQL Server 2000 JDBC Driver SP3 (EXE 安裝)
2. 預設路徑 C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib 下三個 jar：msbase.jar、mssqlserver.jar、msutil.jar
3. 系統環境變數 CLASSPATH 加入三個 jar 完整路徑（分號分隔）

測試程式碼

import java.sql.*;
public class Sql_db_test {
  Connection con; Statement sta; ResultSet rs;
  String sql_driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String sql_url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=manage";
  String user = "xiaolin"; String pwd = "123456";
  public void init() {
    try {
      Class.forName(sql_driver);
      System.out.println("driver is ok");
      con = DriverManager.getConnection(sql_url, user, pwd);
      System.out.println("connection is ok");
      sta = con.createStatement();
      rs = sta.executeQuery("select * from 制衣表");
      while(rs.next()) System.out.println(rs.getString("款式"));
    } catch(Exception e) { e.printStackTrace(); }
  }
  public static void main(String[] args) { new Sql_db_test().init(); }
}

實測異常

driver is ok
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
... (堆疊追蹤略) ...

驅動載入成功但無法建立 Socket 連線，需進一步排查網路/埠/伺服器設定。