Error Connecting from android to MS SQL database

Question

I've been trying to connect from android to Microsoft SQL server's database. But i'm not able to do it. Please help. I've tried so many things. I was using jtds - 1.3.1 i tried using 1.3.0 version also. But still failed. Please help.

public class ConnectionClass {
String ip = "192.168.0.101\\SQLEXPRESS:1433";
String classs = "net.sourceforge.jtds.jdbc.Driver";
String db = "dictionary";
String un = "";
String password = "";

@SuppressLint("NewApi")
public Connection CONN() {
    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder()
            .permitAll().build();
    StrictMode.setThreadPolicy(policy);
    Connection conn = null;
    String ConnURL = null;
    try {

        Class.forName(classs);
        ConnURL = "jdbc:jtds:sqlserver://" + ip + ";"
                + "databaseName=" + db + ";user=" + un + ";password="
                + password + ";";
        conn = DriverManager.getConnection(ConnURL);
    } catch (SQLException se) {
        Log.e("ERRO", se.getMessage());
    } catch (ClassNotFoundException e) {
        Log.e("ERRO", e.getMessage());
    } catch (Exception e) {
        Log.e("ERRO", e.getMessage());
    }
    return conn;
}
}

and i'm getting this error:

E/ERRO: Unknown server host name 'Host is unresolved: 192.168.0.101\SQLEXPRESS'.

I've also tried removing SQLEXPRESS(like this: 192.168.0.101:1033) from above line but then another error is coming.

I've enabled TCP/IP from MS SQL and i've also allowed port 1433 from firewall as well as i've also allowed MS SQL from firewall. MS SQL's allow remote connection is also checked.

Please help. Thanks..

Why not to directly connect to a database from mobile: http://stackoverflow.com/questions/15853367/jdbc-vs-web-service-for-android — Morrison Chang, Sep 12 '16 at 14:31

score 1 · Answer 1 · answered Sep 12 '16 at 14:28

1

That isn't a valid url. You'd need to use either the IP alone, or scheme://ip. However it is NOT recommended to directly connect to a db from a mobile device- doing so requires your password to be in the app, which means anyone who uses the app has access to your password. Use a web service instead and keep the password on your server only for security.

Also, never set the strict mode. First off its a hack. Secondly it doesn't work on all devices. Third of all, if you need it you're going to leave your app unresponsive and quite possibly crashing due to watchdog timers. ANy site you saw using it doesn't know what they're doing.

answered Sep 12 '16 at 14:28

Gabe Sechan

90,003
9
87
127

now it is giving error like this: E/ERRO: Single-Sign-On is only supported on Windows. Please specify a user name. – Abhishek Panjabi Sep 12 '16 at 14:34
Then it needs a username. Although I still do not suggest directly connecting from mobile, if you supply your username it should work. – Gabe Sechan Sep 12 '16 at 15:05
What username I should supply ? I've not set anything.@Gabe Sechan – Abhishek Panjabi Sep 13 '16 at 02:37
What if I connect using tcp socket and my host computer connect with database instead of Android app. Will that be secure ? @Gabe Sechan – Abhishek Panjabi Sep 13 '16 at 02:41

score 0 · Answer 2 · answered Sep 30 '16 at 09:08

This is not true address '192.168.0.101\SQLEXPRESS:1433' just go on like this '192.168.0.101'

Do not try it on your device(sometimes it cant see the server's ip) , firstly try it with any 'Emulator' also dont forget to make network settings on VirtualBox

Error Connecting from android to MS SQL database

2 Answers2