1. Peter Savery
  2. PowerBuilder
  3. Thursday, 11 August 2022 14:12 PM UTC

Folks,

I have a PowerBuilder application that was converted from SAP 12.5 to Appeon 2019 R3 using an Oracle database. We have recently migrated the Oracle database from 12c to 19c. We have a Citrix server the application runs on that has numerous versions of Oracle installed with the 19C as the latest installation. The path has been modified to have the 19C client_1 t the top of the path but when the application runs it does not utilize this path, is there some reason the application is not using this path. Is the pbora.dll expecting a different version of Oracle? Is it not going to utilize the Oracle 19C software?

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 12 August 2022 02:32 AM UTC
  2. PowerBuilder
  3. # 1

Hi,

I'm not a 100% sure if everything will work perfectly, but I've successfuly used an Oracle 19 driver to connect in PB2019R3.

Try setting the TNS_ADMIN environment variable if your oracle version isn't been found. Not sure if that will work on a Citrix server.

If not, use the 12C client, like Roland said.

regards,

MiguelL

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 11 August 2022 15:14 PM UTC
  2. PowerBuilder
  3. # 2

The ORA driver in PB 2019 supports 11g/12c according to the help.

You can use the ORA driver in PB and the 11g/12c version of Oracle Client.

 

Comment
There are no comments made yet.
Peter Savery Accepted Answer Pending Moderation
  1. Thursday, 11 August 2022 14:21 PM UTC
  2. PowerBuilder
  3. # 3

Ok, Thanks for your help.

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 11 August 2022 14:12 PM UTC
  2. PowerBuilder
  3. # 4

AS I understand it, Oracle 19 support will be offered with PBv2022.

Meanwhile, the Oracle 10 driver WILL work with 19C as long as you are not making Oracle-version-specific calls. I have PBv12.5 code that works with Oracle 19c.

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.