While developing a JDBC program that was accessing the Access database I was getting following error:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Please let's know how it can be solved?
Download and install Microsoft Access Database Engine 2010 Redistributable and then try to run your program.
This download contains the libraries need to connect the non Microsoft program such as Java top Microsoft file system.
After installing this patch your java program should be able to connect to Microsoft database.
i am also getting same error, my operating system is Windows 7 64-bit , and using java version-7 32-bit , and office is ms office 2007 32-bit, so what should i do to resolve this error