JAVA连接数据库总是连接不上，请大家帮帮忙，下个星期交项目了。。

[jinxianrui]

错误代码如下：
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包了 怎么就是不对 大家帮我看看 谢谢各位了

[ycagri]

你不会是用Sql2000的JDBC去连接SQL2005吧

[kird_tang]

2000 jdbc可以连到2005，但系连不了2008.

[bingmeng_1102]

有没有打上SQL serverSP3或者sp4？

[jinxianrui]

我没打补丁，怎么还要打补丁啊， 我试试 ，谢谢哈

[yiyi_wx]

http://topic.csdn.net/u/20080405/06/fc8e48d0-b84c-4642-88f0-390a9295a27e.html?1698261955

[emon123]

[专属]

private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=dbname";

不同版本的jar包链接字符串是不一样的，这个链接字符串，你用sqljdbc.jar绝对没哟问题的！

[专属]

sql的版本是2005的额，08的也可以用的！