写了个JDBC连接SQLServer的测试程序,但却出现了如下的错误,大家帮我看下为什么,是不是没有连上数据库呢?
我用的是eclipse ,也在工程中导入了那三个包!
程序如下:

import java.sql.*;

public class MyDB {
    public static void main(String[] args) {

        //加载驱动程序
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ex) {
        }

         String str =
        "jdbc:microsoft:sqlserver://localhost:1433;databasename=hyp";
        try {
            Connection con = DriverManager.getConnection(str,
                    "sa", "");
            Statement sta = con.createStatement();

            ResultSet res = sta.executeQuery("select * from hyp1");

            while(res.next()) {
                System.out.print(res.getString("Sno"));
                System.out.print(res.getString("Sname"));
            }

                  res.close();
            sta.close();
            con.close();

        } catch (SQLException ex1) {
            ex1.printStackTrace();
        }
    }
}
错误如下:
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:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at MyDB.main(MyDB.java:15)

是指SQL Server服务管理器吗?打开了啊!

知道的给回答个啊?

知道的给回答个啊?

现在打了SP3补丁,我还重装了系统,问题是这样的呢?大家帮我看看!程序还是如下!
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class MyDB {
    public static void main(String[] args) {

        //加载驱动程序
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ex) {
        }

         String str =
        "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=hyp";
        try {
            Connection con = DriverManager.getConnection(str,"sa", "");
            Statement sta = con.createStatement();
            ResultSet res = sta.executeQuery("select * from hyp1");
               while(res.next()) {
                System.out.print(res.getString("Sno"));
                System.out.print(res.getString("Sname"));
            }

                  res.close();
            sta.close();
            con.close();

        } catch (SQLException ex1) {
            ex1.printStackTrace();
        }
    }
}
错误如下:
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(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at JDBC.MyDB.main(MyDB.java:19)
如果真连接不好,只能用ODBC连接方法了?不过我觉得这个连接方法啊!那个是不是每次都要配置数据源?

没人回答我,就没人和我情况一样吗?