About Access JDBC ODBC issues

In the school Java curriculum, there is a need to connect JDBC ODBC, and there are a lot of problems when testing on your own computer.

Added the Tomcat course to increase the ODBC requirements for connecting to access JDBC;

Here are the problems and solutions I have appeared

1. System WIN10 64-bit

2. Office 2016

① First, the JDK1.8 version cancels the JDBC ODBC connection mode, changing the JDK1.7 version, of course you can choose the other lower version.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/8A/A5/wKiom1g2VQCwWCnrAAAUtHcvFgo299.png "title=" image 047. PNG "alt=" Wkiom1g2vqcwwcnraaauthcvfgo299.png "/>

② when creating ODBC, there are two options.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/8A/A1/wKioL1g2VayCTNjmAAAZlQmIXQc818.png "title=" image 048. PNG "alt=" Wkiol1g2vayctnjmaaazlqmixqc818.png "/>

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

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/8A/A5/wKiom1g2VqSB_kKWAAHjTqtaHkg690.png "title=" Qq20161124105444.png "alt=" Wkiom1g2vqsb_kkwaahjtqtahkg690.png "/>

④ Create complete Select eclipse for testing, error ([MICROSOFT][ODBC Driver Manager] in the specified DSN, the architecture mismatch between the driver and the application);

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/A6/wKiom1g2W9CyCs_pAAIiPDbpiXs280.png "title=" Qq20161124105638.png "alt=" Wkiom1g2w9cycs_paaiipdbpixs280.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/8A/A5/wKiom1g2WeLQDDGtAABSa9--jFo220.png "style=" float: none; "title=" Image 049.png "alt=" Wkiom1g2welqddgtaabsa9--jfo220.png "/>

⑤ download Access JDBC ODBC 64-bit driver

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

Open ODBC 64-bit data source management program after successful installation will find a few more items;

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/8A/A6/wKiom1g2XOyiWt0AAAIoAIxADXE385.png "title=" Qq20161124112005.png "alt=" Wkiom1g2xoyiwt0aaaioaixadxe385.png "/>

⑥ this resolves an error problem ([MICROSOFT][ODBC Driver Manager] does not match the architecture between the driver and the application in the specified DSN).

About Access JDBC ODBC issues