Steps and solutions for importing MYSQL database structure in PowerDesigner

Steps and solutions for importing MYSQL database structure in PowerDesigner

We are using PowerDesigner today and want to import the MySql table structure to PowerDesginer,

Follow these steps:

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

Download Connector/ODBC 5.1.13 Windows (x86, 32-bit), MSI Installer installation program, 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, enter the ip port and other information, and save it as a file;

3. Prepare for import. In PowerDesigner, use the menu File = "Reverse Engineer =" Database ", choose" MySQL5.0 "for DBMS, and click" OK;

4. In the Selection window of the pop-up Database Reverse Engineering Options window, select Using a data source and click the small Database icon on the right,

In the pop-up window, select ODBC file data source, find the DSN file Created in step 1, enter the User ID and Password below, and click Connect

5. Click OK to bring up the database table selection window. Select the database to be imported and the corresponding table, and click OK to start importing data from MySql.

An error occurred during the import process. I started to download and install the 64-bit ODBC driver in step 1. The result is always in step 3, with an error reported.

SQLSTATE=IM002[Microsoft] [ODBC driver manager does not find the data source name and does not specify the Default Driver

I couldn't find the error after searching on the internet, and I couldn't restart my computer. Later I found that PowerDesigner was 32-bit, And I downloaded the 32-bit ODBC driver again.