Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
wood burning stoves
 
subject: Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch
 
Similar Threads
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ= stopped working
Problem creating a Microsoft Access connection from a file
quotation marks problem of access db,SOS!
Class.forName error
Null data issue