cannot connect to mssql server from java jdbc

Question

I am trying to connect to mssql server from java but I couldnt figure it out. It throws an exception

ERROR: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MLS_J

here is the code below. What am I doing wrong? How can I fix this?

public static String connection_test(){
    String address  = "jdbc:sqlserver://192.168.1.101:1433;DatabaseName=MLS_J";
    String user = "sa";
    String password = "xxxx";

    try {
            Connection conn = DriverManager.getConnection(address, user, password);
            java.sql.Statement stmt = conn.createStatement();

            return "Bağlantı kapalımı? - " + conn.isClosed();


    } catch (Exception e) {
        return "ERROR: " + e.getMessage();
    }

}

I havent done anything for build path. It was working before but suddenly it stopped working. How can I check that? — Arif YILMAZ, Dec 05 '13 at 08:47
@ayilmaz see my answer to see how to add jar files in build path — SpringLearner, Dec 05 '13 at 09:20

score 1 · Accepted Answer · edited May 23 '17 at 12:28

1

You might wanna take a look at this.

Try adding this line to your code:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

edited May 23 '17 at 12:28

Community

1
1

answered Dec 05 '13 at 08:50

Blub

3,762
1
13
24

how do I add sqljdbc4.jar to my classpath? – Arif YILMAZ Dec 05 '13 at 09:02
Are you using eclipse? Then just copy it into your project folder, right-click it and select "Build Path -> Add to Build Path" – Blub Dec 05 '13 at 09:06
Class.forName is not needed for JDBC 4 drivers. If the driver is on the classpath it will be loaded automatically. – Mark Rotteveel Dec 05 '13 at 14:22

SpringLearner · Answer 2 · 2013-12-05T09:26:18.083

1

Follow the steps for adding jar files in build path

Right click on project
click build path-> configure build path
click libraries folder
then click add external jar and give the path of the sqljdbc4.jar.

I would suggest you to use jtds driver.

edited Dec 05 '13 at 09:26

answered Dec 05 '13 at 09:20

SpringLearner

13,738
20
78
116

cannot connect to mssql server from java jdbc

2 Answers2