/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */package jdbc.connection;import java.sql.*;
import java.sql.Connection;
import java.util.logging.Level;
import java.util.logging.Logger;/**
 *
 * @author Administrator
 */
public class JDBC_MSSQL_Connection {
        static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
static String userName = "sa";
static String userPwd = "";
        static Connection con = null;        public static void main(String args[]) throws ClassNotFoundException{
            Class.forName(driverName);
            try {
                con = DriverManager.getConnection(dbURL, userName, userPwd);
                System.out.println("Connection Successful!");
            } catch (SQLException ex) {
                Logger.getLogger(JDBC_MSSQL_Connection.class.getName()).log(Level.SEVERE, null, ex);
            } finally{
                try {
                    con.close();
                } catch (SQLException ex) {
                    Logger.getLogger(JDBC_MSSQL_Connection.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        }
}
run:
2008-12-14 16:50:37 jdbc.connection.JDBC_MSSQL_Connection main
严重: null
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
        at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
        at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
        at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
        at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at jdbc.connection.JDBC_MSSQL_Connection.main(JDBC_MSSQL_Connection.java:27)
Exception in thread "main" java.lang.NullPointerException
        at jdbc.connection.JDBC_MSSQL_Connection.main(JDBC_MSSQL_Connection.java:33)
Java Result: 1
成功生成(总时间:3 秒)
在网上找了好久
找到了两个问题
1.sql server 2000没有升级到sp4
2.TCP/IP端口号没有设置为1433
两个问题我都试了试,结果还是没有解决
请高手帮忙解决一下这个问题
万分感谢