数据库连接问题, 请各位大侠能够指点:在线等待!谢谢

Question

源代码:
 package dd;
import java.sql.*;public class ConnectTosql {
    public ConnectTosql() {    
            String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";         
            try {
                Class.forName(sDBDriver);
                System.out.println("========");
                String sConnStr =
                        "jdbc:microsoft:sqlserver://127.0.0.1:;DatabaseName=pubs";
                String username = "sa";
                String password = "";
                Connection connWeb = null;
                try {
                    connWeb = DriverManager.getConnection(sConnStr,username,password);               } catch (SQLException ex1) {
                    ex1.printStackTrace();
                }
                System.out.println("=============------==");
                System.out.println(connWeb);
                Statement stmt = connWeb.createStatement();
                String query = "select * from jobs";
                ResultSet res = stmt.executeQuery(query);
                System.out.println(res);
            } catch (SQLException ex) {
            } catch (ClassNotFoundException ex) {
                ex.printStackTrace();
           
            }    
    }
    public static void main(String[] args) {
        new ConnectTosql();
        System.out.println("asdf");
    }
}错误代码: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 dd.ConnectTosql.<init>(ConnectTosql.java:31)
at dd.ConnectTosql.main(ConnectTosql.java:43)

Answer 1

应该还是驱动的问题 
我以前用oracle也是这问题 用eclipse导进去的驱动总是找不到 后面手动部署了之后就可以用了.  楼主手动配置一下 试试能不能行

Answer 2

package dd;
import java.sql.*;public class ConnectTosql {
    public ConnectTosql() {    
            String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";         
            try {
                Class.forName(sDBDriver);
                System.out.println("========");
                String sConnStr =
                        "jdbc:microsoft:sqlserver://127.0.0.1:;DatabaseName=pubs";
                String username = "sa";
                String password = "";
                Connection connWeb = null;
                try {
                    connWeb = DriverManager.getConnection(sConnStr,username,password);               } catch (SQLException ex1) {
                    ex1.printStackTrace();
                }
                System.out.println("=============------==");
                System.out.println(connWeb);
                Statement stmt = connWeb.createStatement();
                String query = "select * from jobs";
                ResultSet res = stmt.executeQuery(query);
                System.out.println(res);
            } catch (SQLException ex) {
            } catch (ClassNotFoundException ex) {
                ex.printStackTrace();
           
            }    
    }
    public static void main(String[] args) {
        new ConnectTosql();
        System.out.println("asdf");
    }
}驱动你是装上了,否则会报"类无法找到的错误!".
=================================
String sConnStr ="jdbc:microsoft:sqlserver://127.0.0.1:;DatabaseName=pubs";
String username = "sa";
String password = "";
=================================
sConnStr是否有错误,好像没有看到端口?应该是这样吧号.jdbc:microsoft:sqlserver://127.0.0.1:1344;DatabaseName=pubs
为什么密码为空? 这个可能不重要!