The specified DSN contains an architecture mismatch Error

by

That message appears under the following circumstances:

  • you have the Access Database Engine (a.k.a. “ACE”) installed,
  • you create an ODBC DSN for your database connection, and
  • your Java code is running in a JVM (Java Virtual Machine) whose “bit-ness” is different than that of the installed version of ACE.

For example,

  1. you could have the 32-bit version of ACE installed and be trying to connect from Java code running in a 64-bit JVM, or

  2. you could have the 64-bit version of ACE installed and be trying to connect from Java code running in a 32-bit JVM.

If you really want to use the JDBC-ODBC Bridge then the solution is to either switch to the “other” version of ACE (i.e., switch from 32-bit to 64-bit or vice versa), or have your Java code run under a JVM with the same “bit-ness” as the installed version of ACE.

(Note that if you have Office installed then “switching to 64-bit ACE” really means “switching to 64-bit Office”. You can’t “mix and match” 32-bit and 64-bit Office components.)

However, now that the JDBC-ODBC Bridge has been removed from Java 8 you should consider using the UCanAccess JDBC driver instead. It is a pure Java implementation that does not use Access ODBC to manipulate the database, so it works under both 32-bit and 64-bit JVMs on all platforms that run Java (i.e., not just Windows). For more details, see

Manipulating an Access database from Java without ODBC

More Related Contents:

  1. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  2. JDBC ODBC Driver Connection
  3. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  4. Hours and seconds are lost when storing a date in the database [closed]
  5. Java and NetBeans: Cannot run code from the compiled file
  6. Connection pooling options with JDBC: DBCP vs C3P0 [closed]
  7. ClassNotFoundException com.mysql.jdbc.Driver [duplicate]
  8. Efficient way to do batch INSERTS with JDBC
  9. Java: Insert multiple rows into MySQL with PreparedStatement
  10. What is the actual use of Class.forName(“oracle.jdbc.driver.OracleDriver”) while connecting to a database?
  11. “Uncompilable source code” RuntimeException in netbeans
  12. java.sql.SQLException: Exhausted Resultset
  13. java.util.stream with ResultSet
  14. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  15. JDBC ResultSet get columns with table alias
  16. How to start a transaction in JDBC?
  17. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  18. Driver JDBC PostgreSQL with Android [duplicate]
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  21. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  22. How to setup Main class in manifest file in jar produced by NetBeans project
  23. Where is Visual Web Editor for JavaServer Faces on Netbeans
  24. giving ‘java.library.path’ in netbeans for .dll/.so files
  25. How to correctly write UTF-8 strings into MySQL through JDBC interface
  26. How do you enforce foreign key constraints in SQLite through Java?
  27. How to include custom panel with NetBeans GUI Builder?
  28. Netbean Java Swing, JPanel/Jlabel Cant cover whole Frame
  29. Does a breakpoint halt all threads?
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment