用JDBC连sql server2000的问题
问题:数据连不通
连接数据库的代码如下:<%
try {
//装载驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
out.println("forname success");
//创建连接
Connection con = java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev", "sa", "sa");
Statement stmt = con.createStatement();
ResultSet rst = stmt.executeQuery("select * from contact;");
while (rst.next()) {
out.println("<tr>");
out.println("<td>" + rst.getString("userName") + "</td>");
out.println("<td>" + rst.getInt("mobile") + "</td>");
out.println("<td>" + rst.getString("phone") + "</td>");
out.println("<td>" + trans(rst.getString("mail")) + "</td>");
out.println("<td>" + rst.getDate("lastcontact") + "</td>");
out.println("<td>" + trans(rst.getString("mem")) + "</td>");
out.println("</tr>");
}
//关闭连接、释放资源
rst.close();
stmt.close();
con.close();
}
catch (Exception e) {
out.print("****************************ERROR*****************************<br>");
StringWriter sw=new StringWriter();
PrintWriter pw=new PrintWriter(sw);
e.printStackTrace(pw);
out.print(sw.getBuffer().toString());
out.print("****************************ERROR*****************************<br>");
}
%>
报了一大堆问题,部分如下: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 ...
我的怀疑:1、应该不是驱动程序的问题,因为我在装载驱动程序后面写的out.println("forname success");显示了;
2、错误可能在这里:("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev", "sa", "sa");数据库名、用户名、密码都没问题,注:我装了oracle,8080端口冲突,我把Tomcat的端口改为8081了;
3、在cmd命令符下telnet 127.0.0.1 1433不通。
请问各位高人,这是什么问题,怎么解决?
各位大侠帮忙看看,分不够再加。