Android通过jtds连接sql，加载驱动程序出错，求大神指教

Question

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import android.app.Activity;
import android.database.SQLException;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import net.sourceforge.jtds.jdbc.Driver;

public class MainActivity extends Activity {

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    String UserName = "sa";//用户名  
    String Password = "851202790";//密码  
    Connection con = null;  
    try { // 加载驱动程序  
         Class.forName("net.sourceforge.jtds.jdbc.Driver"); 
        con = DriverManager.getConnection(  
                 "jdbc:jtds:sqlserver://localhost:1433/Drink", UserName,  
                Password);  
    } catch (ClassNotFoundException e) {  
        System.out.println("加载驱动程序出错");  
    } catch (SQLException e) {  
        System.out.println(e.getMessage());  
    } catch (Exception e) {  
        System.out.println(e.getMessage());  

    }  
    try {  
        testConnection(con);//测试数据库连接  
    } catch (java.sql.SQLException e) {  
        // TODO Auto-generated catch block  
        e.printStackTrace();  
    }  
}  

public void testConnection(Connection con) throws java.sql.SQLException {  

    try {  

        String sql = "SELECT * FROM TRight";//查询表名为“table_test”的所有内容  
        Statement stmt = con.createStatement();//创建Statement  
        ResultSet rs = stmt.executeQuery(sql);//ResultSet类似Cursor  

        while (rs.next()) {//<code>ResultSet</code>最初指向第一行  
            System.out.println(rs.getString("authority_url"));//输出第n行，列名为“test_id”的值  
            System.out.println(rs.getString("authority_name"));  

        }  

        rs.close();  
        stmt.close();  
    } catch (SQLException e) {  
        System.out.println(e.getMessage().toString());  
    } finally {  
        if (con != null)  
            try {  
                con.close();  
            } catch (SQLException e) {  
            }  
    }  
}

}

Answer 1

检查下sql server是否启用tcp/ip和远程访问，防火墙。