File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes error connect java with ms access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "error connect java with ms access" Watch "error connect java with ms access" New topic

error connect java with ms access

jim li
Ranch Hand

Joined: May 20, 2008
Posts: 180
Caused by: java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

i am using java and ms access 64, i got the above error. please help
Jan Cumps

Joined: Dec 20, 2006
Posts: 2565

At the moment there is no production 64 bit driver for Access.
Microsoft offers a package that allows you to use Access ODBC in 64 bits mode (not tested by me):

Note that they explicitly say that this is meant to be a solution for opening existing files, and not a replacement for the JET engine. They advize you to move to SQL Server Express.

OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: error connect java with ms access
It's not a secret anymore!