PowerDesigner connect MySQL hint "connection test Failed"

PowerDesigner connect MySQL hint "connection test Failed", how to fix:

1. Replace 64-bit JDK with 32-bit JDK (VM only supports 32 JRE)

2. System Variables:
CLASSPATH = E:\Workspaces\my-jar\mysql-connector-java-5.1.7-bin.jar
Path = D:\Java\jdk1.6.0_13\bin;
Java_home = D:\Java\jdk1.6.0_13\;

3. PowerDesigner Tools---General Options--Variables:
JAR D:\Java\jdk1.6.0_13\bin\jar.exe
JAVA D:\Java\jdk1.6.0_13\bin\java.exe
JAVAC D:\Java\jdk1.6.0_13\bin\javac.exe
JAVADOC D:\Java\jdk1.6.0_13\bin\javadoc.exe

If not, after installing 64-bit ODBC and then installing 32-bit ODBC, you cannot find the ODBC data source driver for MySQL, you need to

Open the directory: "C:\Windows\SysWOW64", double-click the directory under the "Odbcad32.exe" file, go into the ODBC Data source management interface, now this interface has access to the driver!

The installation routines for the Microsoft Access Driver (*.mdb) ODBC driver could not be found. Please reinstall the driver

Follow the method created by the textbook: Control Panel-Administrative Tools-Data Source (ODBC), open the ODBC Data Source Administrator window, then add, open the Create New Data Source window, select the Microsoft Access Driver (*.mdb) option, and so on ...

But I opened the ODBC Data Source Administrator window, but when I added it, I found that there was only one SQL Server driver in the window and there was no access!

Online search solution, the reason may be because the system is win7-64 bit problem, not very understanding!

Attach the workaround: Open the directory: "C:\Windows\SysWOW64", double-click the directory under the "Odbcad32.exe" file, go to the ODBC Data source management interface, now this interface has access to the driver!

PowerDesigner connect MySQL hint "connection test Failed"