How to connect to mssql server using jdbc in android emulator?

Question

I am a beginner to android development. now am trying to connect with MS SQL 2008 R2 via emulator.MS SQL 2008 R2 running on another (server) machine. Am getting the following error:

The TCP/IP connection to the host xxx.xxx.xx.x\SQL2008R2DEV has failed; 
error: null;
verify connection properties.
make sure that instance of SQL server running on the host and accepting TCP/IP connection to the port are not blocked by Windows Firewall.

Note I have done this in java application. and also I can access my database. but why cannot in android program? have any idea?

NOTE: BOTH SERVER AND MY PC ARE CONNECTED VIA LAN.

In your previous question, you are advised not to use JDBC. In this question you are asking the same thing. We don't welcome asking same question multiple times giving different titles but explaining same problem. — NewUser, Mar 04 '13 at 09:23
@Dibya,sorry am new to stackoverflow, so I don't know how to use it. — want to delete, Mar 04 '13 at 09:54

score 5 · Answer 1 · edited May 23 '17 at 10:29

5

Yes it is possible to connect to MSSQL from android emulator. For example if the other system is having IP 192.168.1.2 then you can very use the same IP in your emulator to connect to the database. Anyway using JDBC in android is not encouraged. This link will explain why it not advisable to use JDBC in Android. This is how you can connect to MSSQL database using JDBC:

    try {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
        Connection conn =DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=msdibya;user=dibya;password=dibya;");                   

        System.out.println("connected");
        Statement statement=conn.createStatement();
        ResultSet resultSet=statement.executeQuery("select * from [user]");
        while(resultSet.next()){
            System.out.println(" "+resultSet.getString(1)+" "+resultSet.getNString(2));
        }

    } catch (Exception e) {
        e.printStackTrace();
    }

I hope you have the proper jar files. Don't forget to import them.

edited May 23 '17 at 10:29

Community

1
1

answered Mar 04 '13 at 06:58

NewUser

3,729
10
57
79

Can u give some samples? I trying this but getting some error. Can you help me pls – want to delete Mar 04 '13 at 07:08
@Imran:Do you want to connect with JDBC or have changed your mind? – NewUser Mar 04 '13 at 07:10
Dibya, I have done in java application and also access the database. – want to delete Mar 04 '13 at 07:23
but when am trying in android , it give some exception. what to do? – want to delete Mar 04 '13 at 07:24
"The TCP/IP connection to the host xxx.xxx.xx.x\SQL2008R2DEV has failed; error: "null; verify connection properties. make sure that instance of SQL server running on the host and accepting TCP/Ip connection to the port are not blocked by Windows Firewall." – want to delete Mar 04 '13 at 07:27
not yet.. I think there are two ways, one is connect the phone to pc and run from eclipse, 2nd is to deploy in phone and run it. – want to delete Mar 04 '13 at 08:44
@Imran: I think the problem is emulator has a dummy IP. You can test it. This might be the problem. Install your app in your phone then run the app check if you can connect to the database – NewUser Mar 04 '13 at 08:51
i can access Internet via emulator. and how can check emulator's IP? – want to delete Mar 04 '13 at 08:53
am getting the same error on Tablet also, Can you help me pls? – want to delete Mar 04 '13 at 10:34

score 1 · Answer 2 · answered Mar 04 '13 at 06:12

1

You can't access remote database directly only way to access is through web services in android.Also any network related task don't write on main thread use Asynctask for that.If post your code how you are accessing will be more useful.

answered Mar 04 '13 at 06:12

Narendra

609
1
12
28

can you give some samples for webservice – want to delete Mar 04 '13 at 06:21
you can Google it actually don't know how to write web service you can search it as per your requirements either in JAVA or .NET – Narendra Mar 04 '13 at 06:31

score 0 · Answer 3 · answered Jan 31 '14 at 00:25

0

It is not advisable to create MSSQL connection from android, its better to create web service in server and use out put of web service in android.

answered Jan 31 '14 at 00:25

Mehdei

245
1
4
10

How to connect to mssql server using jdbc in android emulator?

3 Answers3