My Android application does not connect to my SQL Server

Question

I am making an application for User Logging, when executing the emulator I can register users, verifying the users' stock in my Database, but when I execute the application on my phone, it does not connect to my Database.

This is my connection code to the Database:

public class ConnectionDB extends AppCompatActivity {

Connection connection;
    private static String ip = "192.168.1.9";  //"192.168.33.1";
    private static String port = "1433";
    private static String classs = "net.sourceforge.jtds.jdbc.Driver";
    private static String db = "PHOTOGO";
    private static String user = "mizrahijulio";
    private static String password = "julio1207";

    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        }

    //Connection method
    public Connection connectBD(){
         connection=null;
        try {
            //Acces Permition to DB
            StrictMode.ThreadPolicy policicy=new StrictMode.ThreadPolicy.Builder().permitAll().build();
            StrictMode.setThreadPolicy(policicy);

            Class.forName(classs).newInstance();
            connection= DriverManager.getConnection("jdbc:jtds:sqlserver://"+ip+":"+port+";databaseName="+db+";user="+user+";password="+password+";instance=SQLEXPRESS;");


        }catch(SQLException sq){
            Toast.makeText(getApplicationContext(),sq.getMessage(),Toast.LENGTH_SHORT).show();
        }
        catch (ClassNotFoundException cfe){
            Toast.makeText(getApplicationContext(),cfe.getMessage(),Toast.LENGTH_SHORT).show();
        }
        catch (Exception e){
            Toast.makeText(getApplicationContext(),e.getMessage(),Toast.LENGTH_SHORT).show();
        }

        return connection;
    }

    public Connection CloseConnection() throws SQLException {
try{
        if(connection!=null){
             connection.close();}
}
        catch(SQLException sq){
            Toast.makeText(getApplicationContext(),sq.getMessage(),Toast.LENGTH_SHORT).show();
        }
        return connection;
}

Possible duplicate of [The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption](https://stackoverflow.com/questions/18620869/the-driver-could-not-establish-a-secure-connection-to-sql-server-by-using-secure) — Feras Al Sous, Aug 19 '18 at 07:23
Please read: [JDBC vs Web Service for Android](https://stackoverflow.com/q/15853367/295004) — Morrison Chang, Aug 19 '18 at 07:29

score 0 · Accepted Answer · answered Aug 19 '18 at 07:34

0

If your database is local, Your phone and your server computer must be connected to the same network. May be that is the problem, if your phone is connected to SIM network or to any other network which is not same as server computer network and you try to access it, it will not. When talking about your Emulator, it is obviously connected to the server network, hence it works.

Try it, may be that's the issue.

answered Aug 19 '18 at 07:34

Ümañg ßürmån

9,695
4
24
41

So, what options do I have to be able to connect my phone to the SQL SERVER when they are not connected to the same network? – Julio Mizrahi Aug 19 '18 at 08:28
Well first try on the same network. On the same LAN using wifi for Android device. Which ip did you use on emulator? – greenapps Aug 19 '18 at 08:45
Connect your device and server computer to the same network and try if its working. If it works then at least you are confirmed about the issue. – Ümañg ßürmån Aug 19 '18 at 09:03
My phone does not connect to my sql when they are in the same network, and the IP of my Emulator is : 192.168.234.231 – Julio Mizrahi Aug 19 '18 at 09:11
Did your device work in when they both are in the same network? – Ümañg ßürmån Aug 19 '18 at 09:36
yes,now i chage the ip address ad it working, but how a i can make it work in differents network? – Julio Mizrahi Aug 19 '18 at 11:13
You can make it work in other networks by making your server IP as public so that all the network can access it. One more thing, Please accept this answer and upvote it so that others can know about it. – Ümañg ßürmån Aug 19 '18 at 11:17

Shaon · Answer 2 · 2018-08-26T08:34:50.607

0

If you have wifi and your computer and real device (mobile) is connected to the same wifi you can use NGROK software tool to run and debug your app in your real device.

Run the ngrok.exe and type ngrok http 80, it will give you an address like the below image.

Just use the url in your app where you use your ip address. It is best to use.

edited Aug 26 '18 at 08:34

answered Aug 19 '18 at 12:12

Shaon

2,496
26
27

My Android application does not connect to my SQL Server

2 Answers2