JDBC ODBC Driver Connection

by

As mentioned in the comments to the question, the JDBC-ODBC Bridge is – as the name indicates – only a mechanism for the JDBC layer to “talk to” the ODBC layer. Even if you had a JDBC-ODBC Bridge on your Mac you would also need to have

  • an implementation of ODBC itself, and
  • an appropriate ODBC driver for the target database (ACE/Jet, a.k.a. “Access”)

So, for most people, using JDBC-ODBC Bridge technology to manipulate ACE/Jet (“Access”) databases is really a practical option only under Windows. It is also important to note that the JDBC-ODBC Bridge will be has been removed in Java 8 (ref: here).

There are other ways of manipulating ACE/Jet databases from Java, such as UCanAccess and Jackcess. Both of these are pure Java implementations so they work on non-Windows platforms. For details on how to use UCanAccess see

Manipulating an Access database from Java without ODBC

More Related Contents:

  1. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  2. The specified DSN contains an architecture mismatch Error
  3. Can anyone help fix my code [closed]
  4. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  5. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  6. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  7. How to establish a connection pool in JDBC?
  8. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  9. How to install Java 8 on Mac
  10. Access restriction: The type ‘Application’ is not API (restriction on required library rt.jar)
  11. Cannot issue data manipulation statements with executeQuery()
  12. JDBC Class.forName vs DriverManager.registerDriver
  13. IO Error: The Network Adapter could not establish the connection
  14. How to call oracle stored procedure which include user-defined type in java?
  15. How do I connect to a SQL Server 2008 database using JDBC?
  16. Java JDBC Access denied for user [closed]
  17. Why does autoReconnect=true not seem to work?
  18. Java – Can’t use ResultSet after connection close
  19. Timezones in SQL DATE vs java.sql.Date
  20. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  21. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  22. MySQL connector error “The server time zone value Central European Time” [duplicate]
  23. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  24. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  25. Connection cannot be cast to oracle.jdbc.OracleConnection
  26. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver
  27. How do you keep the machine awake?
  28. How to connect to a remote MySQL database with Java?
  29. Postgres UUID JDBC not working
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment