eclipse,Dreamweaver,都连接不上SQL server而且我已经打过SP4补丁
C:\Documents and Settings\xuxin>telnet 127.0.0.1 1433
正在连接到127.0.0.1...不能打开到主机的连接, 在端口 1433: 连接失败C:\Documents and Settings\xuxin>netstat -anActive Connections Proto Local Address Foreign Address State
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:6059 0.0.0.0:0 LISTENING
TCP 61.51.69.244:1373 219.133.48.104:80 ESTABLISHED
TCP 127.0.0.1:1025 0.0.0.0:0 LISTENING
TCP 192.168.0.1:139 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:1027 *:*
UDP 0.0.0.0:1110 *:*
UDP 0.0.0.0:1533 *:*
UDP 0.0.0.0:6000 *:*
UDP 0.0.0.0:6001 *:*
UDP 0.0.0.0:6002 *:*
UDP 0.0.0.0:6003 *:*
UDP 0.0.0.0:6004 *:*
UDP 0.0.0.0:6005 *:*
UDP 0.0.0.0:6006 *:*
UDP 0.0.0.0:6007 *:*
UDP 0.0.0.0:6008 *:*
UDP 0.0.0.0:6009 *:*
UDP 0.0.0.0:6010 *:*
UDP 0.0.0.0:6011 *:*
UDP 127.0.0.1:1028 *:*
UDP 127.0.0.1:1078 *:*
UDP 127.0.0.1:1122 *:*
UDP 127.0.0.1:1788 *:*
UDP 192.168.0.1:53 *:*
UDP 192.168.0.1:67 *:*
UDP 192.168.0.1:68 *:*
UDP 192.168.0.1:137 *:*
UDP 192.168.0.1:138 *:*这是程序代码:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class TestSql {public static void main(String[] args) throws ClassNotFoundException, SQLException {
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xuxin";
String user="sa";
String pass="sa";
Class.forName(driver);Connection conn = DriverManager.getConnection(url,user,pass);
String sql="select * from userinfo";
PreparedStatement pstt = conn.prepareStatement(sql);
ResultSet rs = pstt.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+"\t"+rs.getString(2));
}
conn.close();
}}这个是报错信息:Exception in thread "main" 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:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at SQL.TestSql1.main(TestSql1.java:17)
谢谢大家```帮帮我!!!
C:\Documents and Settings\xuxin>telnet 127.0.0.1 1433
正在连接到127.0.0.1...不能打开到主机的连接, 在端口 1433: 连接失败C:\Documents and Settings\xuxin>netstat -anActive Connections Proto Local Address Foreign Address State
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:6059 0.0.0.0:0 LISTENING
TCP 61.51.69.244:1373 219.133.48.104:80 ESTABLISHED
TCP 127.0.0.1:1025 0.0.0.0:0 LISTENING
TCP 192.168.0.1:139 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:1027 *:*
UDP 0.0.0.0:1110 *:*
UDP 0.0.0.0:1533 *:*
UDP 0.0.0.0:6000 *:*
UDP 0.0.0.0:6001 *:*
UDP 0.0.0.0:6002 *:*
UDP 0.0.0.0:6003 *:*
UDP 0.0.0.0:6004 *:*
UDP 0.0.0.0:6005 *:*
UDP 0.0.0.0:6006 *:*
UDP 0.0.0.0:6007 *:*
UDP 0.0.0.0:6008 *:*
UDP 0.0.0.0:6009 *:*
UDP 0.0.0.0:6010 *:*
UDP 0.0.0.0:6011 *:*
UDP 127.0.0.1:1028 *:*
UDP 127.0.0.1:1078 *:*
UDP 127.0.0.1:1122 *:*
UDP 127.0.0.1:1788 *:*
UDP 192.168.0.1:53 *:*
UDP 192.168.0.1:67 *:*
UDP 192.168.0.1:68 *:*
UDP 192.168.0.1:137 *:*
UDP 192.168.0.1:138 *:*这是程序代码:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class TestSql {public static void main(String[] args) throws ClassNotFoundException, SQLException {
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xuxin";
String user="sa";
String pass="sa";
Class.forName(driver);Connection conn = DriverManager.getConnection(url,user,pass);
String sql="select * from userinfo";
PreparedStatement pstt = conn.prepareStatement(sql);
ResultSet rs = pstt.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+"\t"+rs.getString(2));
}
conn.close();
}}这个是报错信息:Exception in thread "main" 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:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at SQL.TestSql1.main(TestSql1.java:17)
谢谢大家```帮帮我!!!
自己看看你sqlserver版本吧
select @@version
try{
Class.forName(driver); Connection conn = DriverManager.getConnection(url,user,pass);
String sql="select * from userinfo";
PreparedStatement pstt = conn.prepareStatement(sql);
ResultSet rs = pstt.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+"\t"+rs.getString(2));
}
conn.close();
}catch(Exception e){
out.print(e.getMessage());
}
这样就可以捕获异常了!你试试以下代码:(我用的是MySQL)
try{
Connection con;
Statement stmt;
ResultSet rs;
//加载驱动程序,下面的代码为加载MySQL驱动程序
Class.forName("com.mysql.jdbc.Driver");
//注册MySQL驱动程序
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//用适当的驱动程序连接到数据库
String dbUrl = "jdbc:mysql://localhost:3306/BookDB?useUnicode=true&characterEncoding=GB2312";
String dbUser="rdjuser";
String dbPwd = "12345";
//建立数据库连接
con = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
//创建一个JDBC声明
stmt = con.createStatement();
//增加新记录
//stmt.executeUpdate("INSERT INTO books(id,name,title,price) VALUES('289','baobao','Tomcat Bible',44.5)");
//查询记录
rs=stmt.executeQuery("SELECT * from books ");
//输出查询结果
out.println("<center><table border = 1 width = 400>");
while(rs.next())
{
String col1 = rs.getString(1);
String col2 = rs.getString(2);
String col3 = rs.getString(3);
float col4 = rs.getFloat(4);
col1 = new String(col1.getBytes("ISO-8859-1"),"GB2312");
col2 = new String(col2.getBytes("ISO-8859-1"),"GB2312");
col3 = new String(col3.getBytes("ISO-8859-1"),"GB2312");
out.println("<tr><td>" + col1 +"</td><td>" + col2 + "</td><td>" + col3 + "</td><td>" + col4 + "</td></tr>");
}
out.println("</table></center>");
//删除新增加的记录
//stmt.executeUpdate("DELETE FROM books WHERE id = '546'");
//关闭数据库接连
rs.close();
stmt.close();
con.close();
}
//捕获错误信息
catch(Exception e){
out.println(e.getMessage());
}
如果本地运行的话,可以改为ODBC-JDBC连数据库
这样就可以了,我用的就是xp的,就用这两步就可以
实在不行装个mysql一样学习呀