Geek Answers Handbook

Why does my code continue to receive java.sql.SQLException: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified?

can someone help me to have my database connect to java. I tried this for several hours, but I still have this exception: "java.sql.SQLException: [Microsoft] [ODBC Driver Manager] Data source name not found, and no default driver specified?"

public Connector() {
      Connection con;
      Statement st;
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Database.mdb");
        st = con.createStatement(1004, 1008);
    } catch (Exception e) 
        e.printStackTrace();
    }

}

Here is the exception I received:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
+4
source share
1 answer

Java- 64- Java (Java Virtual Machine) ODBC "Jet" Microsoft Access Driver (*.mdb). , "Jet" 32- .

  • Java 32- JVM

  • 64- "Access Database Engine (" ACE ") ODBC Microsoft Access Driver (*.mdb, *.accdb) 64- JVM.

, , JDBC-ODBC Java 8, " ". .

Access Java ODBC

+2

More articles:


All Articles