The steps of importing MySQL database structure in powerdesigner and problem solving

Today using PowerDesigner, to import the MySQL table structure into the Powerdesginer,

Note the following detailed steps:

1, first to ensure that the machine installed MySQL ODBC driver, to http://dev.mysql.com/downloads/connector/odbc/5.1.html

Download Connector/odbc 5.1.13 Windows (x86,32-bit), MSI Installer installer, and install it successfully;

2. Add a File DSN to the data Source (ODBC) of the System Management tool, select MySQL ODBC 5.1 Driver, and enter information such as Ipport. Save as file;

3, then ready to import, in the PowerDesigner, using the menu file= "Reverse engineer=" Database. The DBMS selects MySQL5.0 and clicks OK.

4, in the pop-up database Reverse Engineering Options form of selection, select using a data source, click on the right of the small database icon,

In the pop-up window. Select ODBC file data source and find the DSN files created in step 2nd. Then enter the user ID and password below and click Connect

5, then click OK, you can pop up the database table selection form, select the database you need to import and the corresponding table. Click OK to start importing from MySQL

Problems with the import process, I started in the 1th step is to download the 64-bit ODBC driver and install it. The result is in the 4th step. Always error

SQLSTATE=IM002[MICROSOFT][ODBC Driver Manager did not discover the data source name and did not specify a default driver

Search on the Internet can not find errors, restart the computer is not, and later found that PowerDesigner is 32-bit, and once again downloaded a 32-bit ODBC driver installation, sure enough.

The steps of importing MySQL database structure in powerdesigner and problem solving