how to connect sql server 2008 from my android app -

how to connect sql server 2008 from my android app -

i'm developing android app connect sql server 2008, , source code dbconn.java

public class dbconn { private static connection conn = null ; private static string driver = "net.sourceforge.jtds.jdbc.driver"; private static string db_name = "testdb" ; private static string db_user = "sa" ; private static string db_password = "sa" ; public boolean consqlserver() { log.d("err","start connect sql server") ; seek { class.forname(driver).newinstance(); string connstring = "jdbc:jtds:sqlserver://192.168.1.100:1433/testdb; instance=sqlexpress; user=sa;password=sa"; conn = drivermanager.getconnection(connstring); log.d("success","connection successful "); homecoming true; } grab (sqlexception e) { log.d("err","error connection 1 = " + e.getmessage()); e.printstacktrace(); homecoming false ; } grab (exception ex ) { log.d("err","error connection 2 = " + ex.getmessage()); ex.printstacktrace(); homecoming false ; } } }

i phone call mainactivity.java

public class mainactivity extends actionbaractivity { .... .... dbconn dbconn = new dbconn(); dbconn.consqlserver() ; ... }

androidmanifest.xml

<manifest> ..... <uses-permission android:name="android.permission.internet" /> ..... </manifest>

but got error this

java.sql.sqlexception: network error ioexception: socket failed: eacces (permission denied) @ net.sourceforge.jtds.jdbc.jtdsconnection.<init>(jtdsconnection.java:436) @ net.sourceforge.jtds.jdbc.driver.connect(driver.java:184) @ java.sql.drivermanager.getconnection(drivermanager.java:179) @ java.sql.drivermanager.getconnection(drivermanager.java:213) @ com.noh.connectdb.app.core.dbconn.consqlserver(dbconn.java:35) @ com.noh.connectdb.app.mainactivity.oncreate(mainactivity.java:20) .... .... i run android device via wifi i check connection device can ping server firewall closed port 1433 opened

can 1 help me ?

android sql-server-2008 database-connection