File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch" Watch "Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch" New topic
Author

Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch

James E Baker
Greenhorn

Joined: Jul 28, 2011
Posts: 23
I searched the JDBC forum & Google and found a few discussions but nothing that solved my issues.

WHAT I'M TRYING TO DO
I am trying to access a Microsoft Access database file. My code seems to be sound but I am getting the "architecture mismatch" error shown in the subject line.

WHAT I'M USING
Access file in .mdb format (32-bit), Eclipse (64-bit) and Windows 7 (64-bit)

THE DRIVER
I loaded the driver using C:\Windows\SysWOW64\odbcad32.exe and selected Micosoft Access Driver (*.mdb).

MY CODE
I don't think it has anything to do with the code because it's an architecture mismatch but I'll post it anyway if you're curious. I'll leave out the non-related code and catch statements...

... and main()

So, I am stumped! I cannot figure out why I'm getting this error.

Thanks for looking... James
 
jQuery in Action, 2nd edition
 
subject: Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch
 
Similar Threads
quotation marks problem of access db,SOS!
Problem creating a Microsoft Access connection from a file
Class.forName error
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ= stopped working
Null data issue