1. Mehak Singla
  2. PowerBuilder
  3. Monday, 2 May 2022 08:04 AM UTC

Hi,

I am getting an error when I tried to connect to Oracle DB from Powerbuilder. This issue was resolved when I uninstalled Oracle client 12c, and installed Oracle 11g in its place.

As part of a migration activity my team is moving the Oracle to 19c and need to be able to connect to Oracle DB from Powerbuilder.

Below is the error I am getting:

"Oracle library OCI.DLL could not be loaded"

Attachments (1)
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 2 May 2022 16:48 PM UTC
  2. PowerBuilder
  3. # 1

Hi,

Make sure your PATH doesn't point to any old oracle installations.

Make sure that - if you have it set - the TNS_ADMIN environment variable isn't pointing to an invalid folder.

+ the advice given by Chris and Armeen.

regards.

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 2 May 2022 16:19 PM UTC
  2. PowerBuilder
  3. # 2

Adding to what Chris said, make sure you are using PB 2019 R3 or newer.  Oracle 19c support was added to PB 2019 R3: https://docs.appeon.com/pb2019r3/release_bulletin_for_pb/system_requirements.html#system_requirements_for_powerbuilder

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 2 May 2022 12:20 PM UTC
  2. PowerBuilder
  3. # 3

Hi Mehak;

   The most likely reason is the you probably did not install the 32 bit Oracle Client which the PB IDE needs to connect to your Oracle DB & 32 bit Apps. However, PB can build 64 bit Apps as well, so you might need the 64 bit Oracle Client as well. FWIW: Personally, I always use the Oracle "Instant Client" & install both bitnesses.

   Note that you should always use the DB Client version that matches your DBMS. Thus, I would only recommend that you use the O19C DB Client drivers. Using mismatched software can lead to other DML processing issues. This is also recommended by Oracle. HTH

Regards ... Chris

 

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.