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!