cancel
Showing results for 
Search instead for 
Did you mean: 

PowerDesigner Repository Connection Error ORA-12154 SQLSTATE = 08004

Former Member
0 Kudos

New PowerDesigner User attempting to connect to the Repository.

Executing PowerDesigner 16.5 SP05 PL02 (64-bit), Version 16.5.5.2 (4734) attempting to connect to an Oracle 11 PowerDesigner Repository.  The ODBC Connection type is using the "Oracle in OraClient 11g_home1" Driver (i.e. Oracle Admin 64Bit 11.2.0.4).  When I attempt to Connect to the PowerDesigner Repository from the PowerDesigner Client I received a PowerDesigner - Error dialog containing the following content:

[Oracle][ODBC][Ora]ORA-12154: TNS: could not resolve the connect identifier specified

SQLSTATE = 08004

Accepted Solutions (1)

Accepted Solutions (1)

former_member200945
Contributor
0 Kudos

Go to Control Panel->Administrator Tools->Data Source(ODBC).

Open the connection's property by clicking Configure button.

Click Test Connection button.

Does it work?

If not, please google search ORA-12154. You'll see a lot of posts.

Former Member
0 Kudos

Philip, thank you for the post as I was able to determine the user error.

Answers (0)