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

Resolved PB2021 Support to Oracle 19c Exadata DB

  1. Issue
0
Votes
Undo
  1. Alagu Raja
    Alagu Raja
  2. PowerBuilder
  3. Thursday, 28 October 2021 08:56 AM UTC

Hi,

 

We are migrating our Oracle Database from "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0" to "Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0".

 

To make sure our PB supports cloud DB we are planning to migrate PB from PB2017R2 to PB2021.

 

When setting up DB profile we are getting below error in PB2021,

 

Same error comes up when we try login to this new DB through new Exe as well as old Exe.

All old DBs are connecting fine in PB as well as Exes.

We need help in setting up PB to connect to new DB to proceed with Development of Exe using PB2021 for new DB.

 

More Infos:

I have Oracle Client 11.2 installed in my system.

SQL Developer is able to connect to new DB in same system.

  1. .EXE
  2. PB Classic
  3. PowerBuilder (Appeon)
The new PB application got "login Failed" although...
PB Desktop app will not execute, PBVM190.dll Excep...
Responses (2)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 28 October 2021 18:01 PM UTC
  2. PowerBuilder
  3. # 1

Did your install the correct oracle client (32 bit) for the pb IDE?

You can set an environment variable in windows name TNS_ADMIN to indicate the path to where the tnsnames.ora file is located.

regards.

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 28 October 2021 14:09 PM UTC
  2. PowerBuilder
  3. # 2

1) I assume you added the TNS entry into the TNSNAMES.ORA file for the new databases.

2) As per Chris Pollack O19C compliance was added to PB 2017 R3 in build 1915 (Dec 2019) and PB 2019 build 2170 (Dec 2019). Both of those releases were MR's.

   Ensure you are using the correct version of PowerBuilder.

3) Ensure that you are using the correct driver.


Good Luck,

Olan

Comment
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.