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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "error connect java with ms access" Watch "error connect java with ms access" New topic
Author

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
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

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):
http://www.microsoft.com/downloads/en/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

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