我绝望了,高手帮忙解答(关于sqlserver2000与jdbc连接)送100分!
源码:
import java.sql.*;
class testdb{
public static void main(String[]args) throws Exception{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shenyong";
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 test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getString("姓名"));
System.out.print(" ");
System.out.println(rs.getString("电话"));
}
rs.close();
stmt.close();
conn.close();
}
}
错误信息:
Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer JDBC Dri
ver]Error establishing socket.
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 Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at testdb.main(testdb.java:8)
Press any key to continue...
我的msbase.jar;mssqlserver.jar;msutil.jar放在d:\myfile\下,在classpath里我也设置过了,我用的是sqlserver7,请问我的问题出在哪里?