PowerBuilder 12.5: Oracle Errors

[Former Member]

Running into an issue today and was hoping someone might have an answer.

Our shop is maintaining a PB app and we're using 12.5 Build 2511. I got word today from our users that they're receiving the "Oracle library OCI.DLL could not be loaded" error message.

I know from past experience that having the 64-bit version of the Oracle client causes that problem, so I had one of our desktop people check out the version and it looks like it's the 32-bit that was installed.

However - we noticed that the user's machine had the 12.1.0.2.0 client installed which is not the version I'm running on my own development machine (I'm still on 11.2).

Is my version of PB compatible with that Oracle client, or do we need to look to getting the older client on that machine.

Any insight you guys might have is definitely appreciated.

Brad

[Former Member]

Might be a case when you have updated your oracle version. At least I had same kind of problem when I updated my oracle client version and after update the older version of oci.dll was in the path. Easily tested with renaming directory for the older oci.dll version. In my case I had a directory C:\app\username\product\11.2.0\client_1 which I renamed to C:\app\username\product_xx\11.2.0\client_1 and after that all works fine.

[Former Member]

Hi Eduardo,

I've confirmed that all of our PB DLLs are on the PC in question and the DBMS parameters are correctly set in an application INI file that we deploy to every machine.

The only difference I can see from the problem machine versus all our other users who aren't running into issues is the Oracle Client that was installed is the Oracle 12c client, which is something that's not present on other machines (including my own).

That is more the question - is the Oracle 12c Client compatible with the version of PB we're using for the application?

I've looked at archived posts and the compatibility list on the PB wiki and while the wiki says I need to be on PB 12.6 in order to run it, others have reported they've been able to connect with PB 12.5 and that's adding to my confusion...

Brad

[Former Member]

Also check that the path to the oracle client is in the system path and that the correct oracle client path occurs first, in case there are still path in there that is no longer valid/correct.

[Former Member]

Hello Brad, check that the file pbo10125.dll (or also pbo * .dll) is in the path where the application is running, it checks the path of Oracle (Example: "C: \ oracle \ product \ 11.2. 0 \ client_1 \ BIN ") is at the beginning of the PATH, check that the DBMS is correct: (Example:" SQLCA.DBMS = "O10 Oracle10g (10.0.0)").

Eduardo G.