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(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at datatest.DataTest.main(DataTest.java:16)
=======================================
package datatest;
import java.sql.DriverManager;
import java.sql.*;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.lang.*;
import javax.swing.JOptionPane;
public class DataTest {
public static void main(String [] args ) throws ClassNotFoundException, SQLException
{ JOptionPane.showInputDialog( "start ");
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
JOptionPane.showInputDialog( "connection+++ ");
final Connection con = DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=fabu; ", "sa " , " ");
Statement statement=con.createStatement();
ResultSet set=statement.executeQuery( "select * from cg ");
JOptionPane.showInputDialog( "ok ");
}
}
------解决方案--------------------
1.如果是xp系统的话要把sqlserver的sp4补丁给打上才能打开1433端口。。。
2.加载sqlserver的jdbc的三个驱动包
------解决方案--------------------
应该是没有打sp3补丁的原因。