Unanswered: Problems connecting Java and Microsoft Access db
Hey everyone, I'm in a bit of a conundrum here and I hope somebody can help me out. I'm trying to write a Java application that will be able to manipulate a Microsoft Access db but I've been running into some problems. Currently, I am getting this error message when I run my code in Eclipse:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
I am on Windows 7 Ultimate 64-bit and I know the Access drivers are 32-bit. I've followed the steps on Microsoft's website to connect to the 32-bit drivers but I'm still getting the error.
Everything that I've seen where someone was able to resolve this issue simply followed the above procedure but I keep coming up empty. Any ideas?