sql server 2000和jdbc for sql server 2002都安装好了，但还是出错。

[j4sxw]

classpath也设置好了。
出错：The server encountered an internal error () that prevented it from fulfilling this request.
jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

[hesi726]

检查你的 URL??以及服务器是否已经启动!

[Sundery]

还有需要注意的事，把你的防火墙关掉

[j4sxw]

import java.sql.*;
public class SQLTest{
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String password = "123";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM jobs";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println("Your frist field is " + rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
System.err.println(e);
}
}
}
好像代码应该没有错,帮帮想想哪方面可能没有设置