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

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

Record the specific 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 successfully;

2, in the System Management tool data Source (ODBC) added a file DSN, select MySQL ODBC 5.1 Driver, and enter the IP port and other information, save as a file;

3, then ready to import, in the PowerDesigner, using the menu file= "Reverse engineer=" Database,dbms Select MySQL5.0, click OK;

4, in the popup database Reverse Engineering Options window of the 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 window, select the database you need to import and the corresponding table, click OK, start to import from MySQL

Problems with the import process, I started in the 1th step is to download the 64-bit ODBC driver and install, results in step 4th, has been error

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

On the internet has been searching can not find errors, restart the computer is not, and later found that PowerDesigner is 32-bit, re-download a bit of 32 ODBC driver installation, sure enough.

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