求助:JDBC无法连接SQL Server!!!
legoe 2005-01-03 07:53:42 代码如下:
package a;
import java.sql.*;
public class test {
public static void main(String args[]){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://legoe:1433;DatabaseName=NorthWind";
Connection con=DriverManager.getConnection(url,"a","a");
Statement st=conn.createStatement();
String query="select * from customers";
ResultSet rs=stmt.executeQuery(query);
while(rs.next()){
System.out.println(rs.getString(2));
}
st.close();
con.close();
}catch(Exception ex){
ex.printStackTrace();
}
}
}
出现异常如下:
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at a.test.main(test.java:14)
使用JBuilder X ,在SQL Server中用户已添加,驱动程序已加入,运行总是出现上述异常,说不能与信任SQL Server相关联,不知为什么?