my dog learned polymorphism
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
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: 2543
    
  10

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: error connect java with ms access
 
It's not a secret anymore!