Hi,
 I try to use SQL Server 2000 Driver for JDBC, but also has mistake.
Please help me.

                                        thinks
import java.sql.*;
import javax.sql.*;

public class TestConnection
{
  public static void main(String args[])
  {
    Connection connection;
    Statement statement;
    ResultSet rs;
    String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver" ;
    String sourceURL = "jdbc:microsoft:sqlserver://192.168.0.73:1433";
    String username = "dmtzx";
    String password = "dmtzx";

    try
    {
      Class.forName(driver);
      connection = DriverManager.getConnection(sourceURL, username, password);
      statement = connection.createStatement();
      rs = statement.executeQuery("SELECT * FROM xdjy.xsxxb");

      while(rs.next())
      {
        System.out.println(rs.getString("id") + rs.getString("name"));
      }
      rs.close();
      statement.close();
      connection.close();
    }
    catch(SQLException se)
    {
      System.err.println("SQL Exception :" + se.getMessage());
    }
    catch(ClassNotFoundException ce)
    {
      System.err.println("Class Not Found Exception" + ce.getMessage());
    }
  }
}
SQL Exception :[Microsoft][SQL Server 2000 Driver for JDBC]Error establishing socket

I found the problem which in the code
the mistake is sql.
There are two ways to make the code work well.

One is modification the sourceURL
"jdbc:microsoft:sqlserver://192.168.0.73:1433;databasename=xdjy"

the other is modification the sql
"USE xdjy SELECT * FROM xsxxb"

If you can not see ms-sql-s in your 'netstat -a', this can be because
you are running a version of Microsoft SQL Server 2000 or
MSDE that has known security vulnerabilities
when used in conjunction with your version of Windows.
To reduce virus attacks, the TCP/IP and UDP network ports have been disabled.
To enable these ports, you must install a patch.
http://www.microsoft.com/sql/downloads/2000/sp4.mspx