How do I connect a DSN to Java

Question

I am trying to connect my sql server database to my code in java.

To get started I want to just make sure I can connect to the database via DSN but I am getting the error:

java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver

Here is my code:

package javaapplication1;

import java.sql.*;

public class JavaApplication1 {

    public static void main(String[] args) 
    {
        Connection con;
        Statement stmt;
        ResultSet rs;

        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:SQLACCESS");
            System.out.print("CONNECTION SUCCESSFUL");
        }catch(Exception e)
        {
            System.err.println(e);
        }  
    }
}

The DSN named "SQLACCESS" does not require a username or password. How should I go about connecting the two?

What JDK instance you are using? Oracle, OpenJDK, some other? — Aleh Maksimovich, Oct 13 '17 at 16:38
Possible duplicate of [Removal of JDBC ODBC bridge in java 8](https://stackoverflow.com/questions/14229072/removal-of-jdbc-odbc-bridge-in-java-8) — Aleh Maksimovich, Oct 13 '17 at 17:34
You should be using the SQL Server JDBC driver, not the (removed) ODBC/JDBC bridge. — Mark Rotteveel, Oct 15 '17 at 16:31

Aleh Maksimovich · Answer 1 · 2017-10-13T17:33:28.583

0

Everything starting with sun. is specific to Sun JDK. So it will not work on other instances.

The method you describe doesn't work in Java 8. They have removed the class. There is an article on how to workaround it (but I will look if there is something better): https://community.yellowfinbi.com/knowledge-base/article/moving-the-jdbc-odbc-bridge-from-java-7-to-java-8

You can find information on how to connect to MS Access databse here: http://www.javaxt.com/Tutorials/JDBC/How_to_Open_a_JDBC_Connection_to_Microsoft_Access

edited Oct 13 '17 at 17:33

answered Oct 13 '17 at 16:43

Aleh Maksimovich

2,622
8
19

Unfortunately this is not using a DSN – SQLUser Oct 13 '17 at 17:28

How do I connect a DSN to Java

1 Answers1