Connecting to SQL Server 2014 from Android Studio

debugcn Published at Dev

KonradK

I have a problem connecting to SQL-server database through from my android project. I have added sqljdbc41.jar file to my /app/libs directory and I have added it to dependencies in my android studio project.

I use following code:

package com.konrad.rezerwacje1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;



public class Database_Console {

public static void openConnection(){
    try {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"‌);
        String url = "jbdc:sqlserver://127.0.0.1:1433;databaseName=my_db";
        Connection con = DriverManager.getConnection(url);
    } catch (SQLException e) {
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
}

public static void main(String[] args){
    openConnection();
}
}

yet i still get this error

java.sql.SQLException: No suitable driver found for jbdc:sqlserver://127.0.0.1:1433;databaseName=my_db
    at java.sql.DriverManager.getConnection(DriverManager.java:689)
    at java.sql.DriverManager.getConnection(DriverManager.java:270)

YCF_L

Instead of this :

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"‌);
String url = "jbdc:sqlserver://127.0.0.1:1433;databaseName=my_db";

You have to use this :

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=my_db";

Connection con = DriverManager.getConnection(url, "username", "password");

Note the different classname, and the fact that prefix jbdc in the URL has been changed to jdbc.

Collected from the Internet

Please contact [email protected] to delete if infringement.