Java database Connection (JDBC-ODBC mode)
Environment: Win7 64-bit and NetBeans IDE 7.1.2 jdk1.7.0_17 (64-bit)
Write the program and run the error: java.sql.SQLException: [MICROSOFT][ODBC Driver Manager] in the specified DSN, the architecture between the driver and the application does not match.
Note: The Win7 64-bit configuration data source, Control Panel-administrative tool Open Data Source (ODBC) will not find the driver because it is a 64-bit operating system, but 32-bit office is installed. Need to be on the road
diameter "C:\Windows\SysWOW64\odbcad32.exe" open , but this opens the 32-bit ODBC (SYSWOW64 is a subsystem of the Windows operating system and is capable of running 32-bit application Windows operating system programs).
The program still reports the same error after the change. Later on a variety of online looking for information, said JDK to install 32-bit, and I installed a 64-bit JDK, connect 32-bit ODBC natural error. And then uninstalled the 64-bit
JDK, 32-bit installed, the database connection was successful.
Java.sql.SQLException: [MICROSOFT][ODBC Driver Manager] in the specified DSN, the architecture between the driver and the application does not match