Connect to SQL Server Database using jdbc Java, Android app

Question

Can you help me, please? I'm trying to create an Android app, which will connect to SQL Server Database. I'm using JDBC driver and:

Added JDBC in Projects Setting -> Library (shown in External Libraries)

The code of connecting to DB is as follows:

try {
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    String url = "jdbc:sqlserver://xxx.x.x.x:yyyy;integratedSecurity=true;"
    con = DriverManager.getConnection(url);
    if (con != null) {
        tv.setText("Connected");
    } else {
        tv.setText("Not connected");
    } catch (Exception ex) {
    tv.setText("" + ex);
}

Eventually, I receive an Exception, that Driver com.microsoft.jdbc.SQLServerDriver not found

If I run the same Console app on Java app, it works.

No. Actually, I plan Android app to connect to a SQL Server, that is on my home computer — Aleksandr
– Aleksandr, Commented Nov 1, 2017 at 6:09
then you dont need driver in your android app, just make a web service — Randyka Yudhistira
– Randyka Yudhistira, Commented Nov 1, 2017 at 6:16

Mykola Tychyna · Accepted Answer · 2017-11-01 07:08:48Z

1

The proper way is add rest api at home server and use on phone to connect and exchange data. Its not enterprise java and it wouldn't work properly.

answered Nov 1, 2017 at 7:08

Mykola Tychyna

1702 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aleksandr Over a year ago

Thank you so much! The trouble was, I didn't add jdbc library in the project properly. The next problem I faced is that network connection goes via main thread. So I need to create a separate thread for SQL Server connection

Collectives™ on Stack Overflow

Connect to SQL Server Database using jdbc Java, Android app

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related