• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error connect java with ms access

 
jim li
Ranch Hand
Posts: 180
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic