我用JAVA 连SQL 2000 总是报错误，麻烦大家帮忙看下，高手指点指点。

Question

错误代码如下：
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 com.util.DBConn.getConn(DBConn.java:21)
at com.bean.LoginBean.login(LoginBean.java:18)
at com.servlet.LoginServlet.doGet(LoginServlet.java:41)
at com.servlet.LoginServlet.doPost(LoginServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2010-7-1 9:05:58 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet LoginServlet threw exception
java.lang.NullPointerException
at com.bean.LoginBean.login(LoginBean.java:20)
at com.servlet.LoginServlet.doGet(LoginServlet.java:41)
at com.servlet.LoginServlet.doPost(LoginServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)我的JDBC 代码是这样写的：
package com.util;import java.sql.*;
public class DBConn {
    static{
        try{
         Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");    
        }catch(Exception ex){
            ex.printStackTrace();
        }    }    public static Connection getConn(){
        try{      Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://local:1433;databasename=PAIKE","sa","12345");
                    return conn;
        }catch(Exception ex){
            ex.printStackTrace();
            return null;
        }
    }
    public static void close(Connection conn,Statement st,ResultSet rs){
     if(rs!=null){
            try{
                rs.close();
            }catch(SQLException ex){
            }
       }
       if(st!=null){
           try {
               st.close();
           }catch(Exception ex){
           }
       }
       if(conn!=null){
           try{
               conn.close();
           }catch(Exception ex){
           }
       }
    }}
我也下.JAR包了  怎么就是不对  大家帮我看看  谢谢各位了

Answer 1

 Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://local:1433;databasename=PAIKE","sa","12345");
  把这的“local:1433”改成你数据库服务器的名字，把端口去掉，把防火墙关了，让数据库默认1433端口，然后看看嫩不能链接上

Answer 2

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
这就是说明数据没有链接上，在数据库链接上找原因，

Answer 3

java直连sqlserver2000必须要打sp4的补丁的，一般都是这个问。

Answer 4

http://tech.163.com/05/0830/15/1SDQL2CI00091589.html
给你个网址，用别人的方法试试

Answer 5

DriverManager.getConnection("jdbc:microsoft:sqlserver://local:1433;databasename=PAIKE","sa","12345");
改一下 可能是这里出的问题  现在不这样写了
改后
DriverManager.getConnection("jdbc:sqlserver://local:1433;databasename=PAIKE","sa","12345");