aspose file tools*
The moose likes JDBC and the fly likes error involving 64-bit windows 7, can't figure it out 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 involving 64-bit windows 7, can Watch "error involving 64-bit windows 7, can New topic
Author

error involving 64-bit windows 7, can't figure it out

Kody Wright
Ranch Hand

Joined: Mar 06, 2011
Posts: 32
Hello all,

I've been working on a program for one of my classes, and I keep running into this same error. After doing some research I found that the problem lays in my OS's initial compatibility with Microsoft Access.

Here is the error: java.sql.SQLException:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and the Application

Now, I've already tried a couple different things to try and fix this (I'll list what I've tried below), but to no avail. I am sure that there has to be someone else out there who has experienced a problem like this before but managed to solve it. (I'm running Windows 7 64-bit Professional Edition.)

1) installing the 64-bit drivers for Microsoft Access (this fails and brings up an error saying that I must first uninstall my 32-bit version first, but after I did more research, it turns out that the 64-bit
drivers are already installed on my computer, they are just hidden in the sysWOW64 folder)

2) redirecting the "Target" and "Start in: " folders to "%windir%\syswow64\odbcad32.exe" instead of the original folder, which only held the 32-bit drivers.

Thanks in advance for the help, it's greatly appreciated!
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2503
    
    8

Can you check this thread about the same subject?


OCUP UML fundamental and ITIL foundation
youtube channel
Kody Wright
Ranch Hand

Joined: Mar 06, 2011
Posts: 32
Ah yes, well that was the first thing I did (#1). I called it the 64-bit driver, guess that's not the correct name lol. Unfortunately it changed nothing for me : (
 
jQuery in Action, 2nd edition
 
subject: error involving 64-bit windows 7, can't figure it out