Don't you know how to connect to the Oracle database during the operation of PowerDesigner? Today, the editor will introduce the method of connecting powerdesigner to Oracle database. I believe that by studying the tutorial of connecting powerdesigner to Oracle database, everyone will definitely know more about powerdesigner software!

Note: The installation directory of powerdesigner cannot have spaces, otherwise an error message of Uable to connect, SQLState=08004, ORA-12154: TNS: Unable to parse the specified connection identifier will be reported when testing the connection.

Establish a connection, win7 system, 64-bit, Oracle server is remote 11g, only 32-bit 10g Oracle client is installed locally.

The database connection was successful.

At this time, double-click C:WindowsSysWOW64odbcad32.exe and find the appxianwang data source.

The editor directly opened the management tools -> data source (ODBC), but there is no Oracle driver.

The 64-bit ODBC manager is opened in the control panel of the 64-bit system and the 64-bit driven data source is established. 32-bit applications will not be able to use the 64-bit data source.

The above explains how powerdesigner connects to the Oracle database. I hope friends in need can learn it.