Java. SQL. SQLException: [Microsoft] [ODBC driver manager] in the specified DSN, the architecture between the driver and the application does not match, odbc driver Manager
Java database connection (JDBC-ODBC Mode)
Environment: win7 64-bit and NetBeans IDE 7.1.2 jdk1.7.0 _ 17 (64-bit)
After the program is written, the following error occurs: java. SQL. SQLException: [Microsoft] [ODBC driver manager]. In the specified DSN, the architecture between the driver and the application does not match.
Note: The driver cannot be found when you open the data source (ODBC) in the control panel-> win7 64-bit configuration data source, because it is a 64-bit operating system, however, the 32-bit office is installed. You need
Open the path "C: \ Windows \ SysWOW64 \ odbcad32.exe", but the 32-bit ODBC (SysWOW64 is a windows operating system subsystem, can run 32-bit windows operating system programs ).
After modification, the program still reports the same error. Later, I asked for information on the Internet, saying that JDK should also be installed with 32 bits. While I installed a 64-bit JDK, a 32-bit ODBC connection error occurs naturally. Then, 64-bit is uninstalled.
JDK, 32-bit installed, database connection successful.