• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PB 2019 R3 64 Bit app - Can't connect DB - ORA-12154 : TNS: Could not resolve connect identifier

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PB 2019 R3 64 Bit app - Can't connect DB - ORA-12154 : TNS: Could not resolve connect identifier

  1. Issue
0
Votes
Undo
  1. Shilpa Bansal
    Shilpa Bansal
  2. PowerBuilder
  3. Thursday, 14 September 2023 21:58 PM UTC 
Can't connect DB - ORA-12154 : TNS: Could not resolve connect identifier

*Reproduce Steps:
1. Build PB application in 64 bit.
2. Oracle 19c clients are installed both 32bit as well as 64 bit as per the requirement of PB 2019 R3 IDE.
3. Set path variables to include both 64bit and 32 bit oracle client installations
4. DBMS=ORA set in .ini file
5. When running app from exe, getting error "Can't connect DB - ORA-12154 : TNS: Could not resolve connect identifier"
5. PB 2019 R3 IDE is able to connect to DB successfully.

Anyone faced similar issue?
Attachments (1)
DBError1.png DBError1.png
Why empty lines for autosize height field in previ...
How to do a GIT reset on uncommitted changes
Responses (2)
Shilpa Bansal
Shilpa Bansal Accepted Answer Pending Moderation
  1. Friday, 15 September 2023 15:33 PM UTC
  2. PowerBuilder
  3. # 1

@Rene : Yes the sqlnet and tnsnames.ora files are same in both 32bit and 64bit oracle client.

i tried setting ORACLE_HOME and TNS_ADMIN env variables both at user and system level, bit still getting this error. Any specific config I need to put in the app.ini file ?

Comment
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Friday, 15 September 2023 04:44 AM UTC
  2. PowerBuilder
  3. # 2

Do you resolve Oracle connection identifier using tnsnames.ora?

Do you have same settings for this file in 32 and 64 bit oracle client?

Check your settings for ORACLE_HOME. 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 15 September 2023 09:24 AM UTC
... or set the TNS_NAMES environment variable to point to the directory where you TNSNAMES.ORA file is.

regards.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.