这是报错
Exception in thread "main" 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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at BB.main(BB.java:34)
最基本的连接数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;/**
*
*//**
* @author Administrator
*
*/
public class BB { /**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
* @throws IllegalAccessException
* @throws InstantiationException
*/
public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {
// TODO Auto-generated method stub
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"; String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from Employees"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {
rs.getString(1); rs.getString(2);
}
System.out.println("SUCCESS");
rs.close(); stmt.close(); conn.close(); }}这是我的CLASSPATH
C:\jdk1.5.0_08\lib\dt.jar;.;C:\jdk1.5.0_08\lib\tools.jar;C:\Program Files\Altova\xmlspy\XMLSpyInterface.jar;C:\bea\weblogic81\server\lib\weblogic.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jarODBC的SP3补丁也打了,SP4补丁也打了,防火墙也关了,三个JAR包,几乎所有的地方都拷进去了,现在不管是ODBC也好,JDBC也好,全都连不上
我问了老师,他说从来没有遇到过我几乎看了所有的论坛,没有找到过答案,我求求你们了,帮帮我吧,我都快急死了
Exception in thread "main" 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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at BB.main(BB.java:34)
最基本的连接数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;/**
*
*//**
* @author Administrator
*
*/
public class BB { /**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
* @throws IllegalAccessException
* @throws InstantiationException
*/
public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {
// TODO Auto-generated method stub
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"; String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from Employees"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {
rs.getString(1); rs.getString(2);
}
System.out.println("SUCCESS");
rs.close(); stmt.close(); conn.close(); }}这是我的CLASSPATH
C:\jdk1.5.0_08\lib\dt.jar;.;C:\jdk1.5.0_08\lib\tools.jar;C:\Program Files\Altova\xmlspy\XMLSpyInterface.jar;C:\bea\weblogic81\server\lib\weblogic.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jarODBC的SP3补丁也打了,SP4补丁也打了,防火墙也关了,三个JAR包,几乎所有的地方都拷进去了,现在不管是ODBC也好,JDBC也好,全都连不上
我问了老师,他说从来没有遇到过我几乎看了所有的论坛,没有找到过答案,我求求你们了,帮帮我吧,我都快急死了
补充一下,NETSTAT -A命令后,列表里面,MSSQL的1433端口没有被监听,重启MSSQL服务器还是一样,
有人说SP2卸掉就好了,我觉得问题可能出现在端口监听这里
不能的话就是sqlserver的问题了
1查一下开始里面有没有“服务管理器”,没有的话就是说你没有服务端的支持
2查一下注册了服务吗