About mysql-ODBC driver installation configuration in 64-bit win7 _ MySQL

Install and configure the mysql-ODBC driver in 64-bit win7

To use powerdesigner, you need to configure ODBC. after repeated failures, the following knowledge points are summarized:

1. there are some bugs in ODBC drivers of different versions of mysql5. if you cannot change the number, this method is generally useful.

2ODBC has two versions in windows, one in system32 and the other in systemWOW64.

After going in, we can see that the driver is different. Theoretically, the 64-bit system should be configured with reference to systemWOW64. The ODBC configurator identified by the program prevails.

If it is an invalid string after configuration, it is a version bug of the driver and requires patching, we recommend that you change the version directly.

3. My computer is just the opposite in theory. I have installed three or more 64-bit drivers, but I cannot see them in wow64. a friend reminded me that I tried it with a 32-bit driver, instead, you can see it. The program also recognizes 32-bit drivers.

I don't think the number of digits is important. The key is to connect them. This is a strange phenomenon, but I encountered a similar problem. I used to install SQLyog64-bit, but I encountered an error when I opened it. I found another 32-bit solution, as a result, when the 32-bit software was installed, the 64-bit software was also recovered. I had my brain filled up. maybe it was too lonely before, so I won't delete it in the future. let them be a companion.

4. you are not recommended to change ODBCinst in the registry when uninstalling the SDK. ini, sometimes the installation string will prompt that the driver cannot be found, the dsn error is messy, don't worry, use the original installation program remove, change the version, although the configuration can still be seen in the provisioner, it cannot be deleted, but it is difficult to make a mistake. leave it alone.

We also recommend a PDMreader, which is used in the powerdesigner Dictionary. the exported table is refreshing.