About the Access JDBC ODBC problem

There is a need to connect Java in the school teaching jdbc odbc curriculum, and there are a lot of problems when testing on our own computers.

The following are my own problems and solutions

System WIN10 64 bit

Office 2016

① first, the JDK1.8 version cancels the connection mode of JDBC ODBC and changes it to the JDK1.7 version. Of course, you can choose other lower-level versions.

When ② creates an ODBC, there are two options.

③ 64-bit open after none, Microsoft Access Driver option, select 32-bit to create.

After ④ creation, select eclipse to test and report an error ([Microsoft] [ODBC driver Manager] in the specified DSN, the architecture between the driver and the application does not match)

⑤ downloads Access JDBC ODBC 64-bit driver

Download address: http://www.microsoft.com/en-us/download/details.aspx?id=13255

When you open the ODBC 64-bit data source manager after a successful installation, you will find several more items.

⑥ thus solves the problem of error reporting ([Microsoft] [ODBC driver Manager] in the specified DSN, the architecture mismatch between the driver and the application).