aspose file tools*
The moose likes JDBC 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

Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
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: 2510

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
youtube channel
I agree. Here's the link:
subject: error connect java with ms access