wood burning stoves 2.0*
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
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: 2516

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: http://aspose.com/file-tools
subject: error connect java with ms access