数据库就是死活连接不上...郁闷呀!!!!!!在线等呀.

[yjws]

java.sql.sqlexception:[Microsoft][sqlserver 2000 driver for jdbc]error establishing socket.
java.lang.NullPointerException


import java.sql.*;
import java.awt.*;
import java.awt.event.*;

class Access extends Frame
{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
int RowCount=0;
public Access()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("1");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://TOMATO-9278C742:1433;databasename=kaopingdb","sa","");
System.out.println("1");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from user_tab");
rs.last();
RowCount=rs.getRow();
rs.first();
while(!rs.isLast())
{

System.out.print(rs.getString("u_yonhu")+" ");
System.out.print(rs.getString("u_mima")+" ");
System.out.println(rs.getString("u_quanxian")+" ");
rs.next();

}
System.out.print(rs.getString("u_yonhu")+" ");
System.out.print(rs.getString("u_mima")+" ");
System.out.println(rs.getString("u_quanxian")+" ");


}
catch(Exception ex)
{
System.out.println(ex.toString());
}
try
{
rs.close();
stmt.close();
con.close();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}

public static void main(String args[])
{
Access mainFrame = new Access();
}
}

[liuya1985liuya]

("jdbc:microsoft:sqlserver://TOMATO-9278C742:1433;databasename=kaopingdb","sa","");
把TOMATO-9278C742改成127.0.0.1

[yjws]

还是一样的问题...

[koskinen]

搞清楚数据库IP ,用户,和密码

[yjws]

那些应该没有问题的??

[lixiaoxue85]

XP系统的话~SP3打了没?防火墙关了没?最主要的看1433这个端口是否BLOCKED了
和程序没关系

[sunny_110119]

要把SQL server驱动程序的三个jar包添加到 工程里来的

[huihui0103]

打上sp4补丁

[zhkchi]

打补丁...谢谢!!

这个问题我起码不下回复了10次了..

唉...

[yjws]

补丁也打了呀?????
打了sp4的的补丁
是这个文件吧SQL2000-KB884525-SP4-x86-CHS.exe

[yjws]

搞定了..
谢谢各位大吓呀.....