Linking an Access database to NetBeans IDE 8.02 without using JDBC-ODBC

Question

How do I link my database to NetBeans without using jdbc.odbc? When I run the program it doesn't link.

public void connect() {
   try {
       String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
       Class.forName(driver);

       String database1 = "jdbc:odbc:database1";
       con = DriverManager.getConnection(database1);
       st = con.createStatement();
   }
}

Which Java version are you using? The slow and buggy JDBC/ODBC bridge (which has always been deprecated) has been removed in Java **8** — a_horse_with_no_name, May 09 '15 at 06:45
possible duplicate of [Manipulating an Access database from Java without ODBC](http://stackoverflow.com/questions/21955256/manipulating-an-access-database-from-java-without-odbc) — Gord Thompson, May 09 '15 at 12:25

score 0 · Answer 1 · answered May 09 '15 at 06:21

0

Register you ms-access file (*.accdb) as a odbc data source.
http://www.mundayweb.com/progs/jdbc-odbc-tut.php

answered May 09 '15 at 06:21

shanmuga

3,667
2
16
33

Linking an Access database to NetBeans IDE 8.02 without using JDBC-ODBC

1 Answers1