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

Source: Internet
Author: User
Tags powerdesigner
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.