SQLServer JDBC sp2 连接错误:Error establishing socket. 来者有分!
疯癫行者 2004-03-22 10:08:53 SQLServer JDBC sp2 连接错误:Error establishing socket.
环境:
windowsXP
sql server 2000 personal edition english version with sp3
代码:
public class SQLServerConnect{
public static void main(String[] args){
try{
new com.microsoft.jdbc.sqlserver.SQLServerDriver();
String sConn = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;User=sa;Password=sa";
Connection conn = DriverManager.getConnection(sConn);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from authors");
while(rs.next()){
System.out.println(rs.getString("au_id"));
}catch(SQLException ex){
ex.printStackTrace();
}
}
}