问题描述
用jtds连接SQL server数据库,驱动加载成功,连接时报错,在网上找了没有看到遇到相同问题的,特来求救
问题相关代码
public Connection Connect_Init(){
Connection con = null;
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
long in1 = System.currentTimeMillis();
try {
con = DriverManager.getConnection("jdbc:jtds:sqlserver://43.98.12.245:1433/zhengyuhu_test;charset=utf-8","sa","sdpwls01#");
} catch (SQLException e) {
Log.e(TAG, "Can not connect sqlserver:"+ e.getSQLState()+" ,error message:"+ e.getMessage() );
}
long end = System.currentTimeMillis();
System.out.println("连接耗时:"+(end - in1)+"ms");//连接耗时
System.out.println(con);
} catch (ClassNotFoundException e) {
Log.e(TAG, "Connect_Init:can not find Driver,make sure you have include in DB " );
}return con;
}
}
运行结果及报错内容
E/SqlServerDB: Can not connect sqlserver:08S01 ,error message:Network error IOException: socket failed: EPERM (Operation not permitted)
我的解答思路和尝试过的方法
尝试换sqljdbc41,结果还是报同样的错误,怀疑是安卓配置问题,但不清楚错误在哪里
我想要达到的结果