How to resolve java.sql.SQLException: No suitable driver found for SQLServer 2008 R2?

Question

I have a sample code to connect to SQLServer is given below :

Connection conn=null;
try {
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
     conn= DriverManager.getConnection(" jdbc:sqlserver://localhost:1433;instance=SQLEXPRESS;databaseName=Test" );

    System.out.println("connected");


} catch (ClassNotFoundException e) {
    e.printStackTrace();
} catch (SQLException e) {
    e.printStackTrace();
}

When I execute this code, I'm getting an exception given below :

java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;databaseName=Test
    at java.sql.DriverManager.getConnection(DriverManager.java:689)
    at java.sql.DriverManager.getConnection(DriverManager.java:270)
    at JDBCSample.main(JDBCSample.java:14)

Why is there a space before `jdbc` in your connection url? And it should be `database` not `databaseName` last time I did this, but that could be synonymous or have changed in versions — BeUndead, Sep 16 '20 at 14:17
Use the site search box, there are many questions with that same error such as [this one](https://stackoverflow.com/questions/1911253/the-infamous-java-sql-sqlexception-no-suitable-driver-found). Update your question with how your situation is different and what you have already tried. — Sander, Sep 16 '20 at 14:17

Anish B. · Accepted Answer · 2020-09-16T15:03:32.443

1

I think the jar for SQLServer is not supporting or typo in the connection string.

Download SQLServer 2008 R2 compatible jar from here :

https://www.microsoft.com/en-in/download/details.aspx?id=11774

Steps :

Click on Download :

Select sqljdbc_6.0.8112.200_enu.tar.gz or sqljdbc_6.0.8112.200_enu.zip if shown.

Click on Next to start downloading.
After downloading, extract the content. Now, go into sqljdbc_6.0/enu/jre8 or sqljdbc_6.0/enu/jre7and copy the jar based on the jdk you are using.

Add the jar in the classpath of the project.

Fix this line

Connection conn = DriverManager.getConnection(" jdbc:sqlserver://localhost:1433;databaseName=Test" );

to this by removing space.

Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Test");

edited Sep 16 '20 at 15:03

answered Sep 16 '20 at 14:20

Anish B.

7,321
3
12
33

@nazaninn Is this helpful? – Anish B. Sep 16 '20 at 14:21
1

Would this not result in a `ClassNotFoundException` from the `Class.forName` call if it wasn't included on the classpath? – BeUndead Sep 16 '20 at 14:25
1

Edited answer would now be my best guess on how to resolve this. I'll upvote if the user in question (@nazanin n) confirms it resolves the issue for them. – BeUndead Sep 16 '20 at 14:28
1

I did what you said but I still get the error @AnishB. – nazanin n Sep 16 '20 at 14:31
@nazaninn Did you change the connection string ? – Anish B. Sep 16 '20 at 14:32
@nazaninn Check for driver. I added the link. follow that link and download the appropriate jar. – Anish B. Sep 16 '20 at 14:36
1

@AnishB. I do not know which version is a correct one i am using sql server 2008R2 – nazanin n Sep 16 '20 at 14:47
@nazaninn I'm checking. Basically, they are removing support for older versions. – Anish B. Sep 16 '20 at 14:48
@nazaninn I got the jar. – Anish B. Sep 16 '20 at 14:55
1

@AnishB. the one in the answer ?? thank you so much – nazanin n Sep 16 '20 at 15:01
@nazaninn I'm updating my answer. – Anish B. Sep 16 '20 at 15:01
@nazaninn I have updated my answer. This much I found for you. – Anish B. Sep 16 '20 at 15:03
@nazaninn Is this helpful ?? – Anish B. Sep 16 '20 at 15:08
@nazaninn Please mark this as accepted answer and upvote if it was helpful ? – Anish B. Sep 16 '20 at 16:06
1

@AnishB. actually it was not helpful I used them and I sill get the error – nazanin n Sep 17 '20 at 09:33

score 0 · Answer 2 · answered Sep 16 '20 at 14:20

0

Seems like you need an JDBC driver supporting your type and version of your SQL Database. Maybe your version of the driver is the wrong one? You should check this out: https://javarevisited.blogspot.com/2016/09/javasqlsqlexception-no-suitable-driver-mysql-jdbc-localhost.html What is the DriverManager doing at lines 689 and 270?

answered Sep 16 '20 at 14:20

Uniqueusername

15
3

my SQL server is 2008 r2 which version I should use? – nazanin n Sep 16 '20 at 14:33
https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15 Check out the "SQL version compatibility" I think thats what you are looking for. – Uniqueusername Sep 16 '20 at 14:36

How to resolve java.sql.SQLException: No suitable driver found for SQLServer 2008 R2?

2 Answers2