POWER BUILDER 12.6 WITH 64 BIT ORACLE INSTANT CLIENT 12

[Former Member]

Hi,
i've installed PB12.6 trial version, and try to connect with Oracle 64bit instant client v.12.
OS is win10.
Connecting with sqlplus always is ok, but when i try to connect from DB profile in the PB panel, i get the "Oracle library OCI.DLL could not be loaded" error.
If i switch to the Oracle 32bit instant client v.12 (placed in another path and setting the ORACLE_HOME, PATH and TNS_ADMIN environment variable) it works.
So i can't understand if with Powerbuilder 12.6 is possible connecting with 64 bit Oracle client.

Any suggestion?

Regards

Luca Militello

[Former Member · Accepted solution]

You are Correct.

The bitness of the Oracle Client must match the program using it. The PB IDE is 32bit and can generate 32bit or 64bit executables.

[Former Member]

Ok, thank you very much!

Luca

[Former Member]

Hi Chris,
and so i have to compile 64bit .exe using 32bit oracle connection from Pb environment, and then switch to 64 bit client
to use the compiled app with 64bit db connection. Right?

Luca

[Former Member]

Hi Luca;

Your PB Applications can be compiled into 64bit .EXE's which can then utilize the 64bit Instant Client.

Regards ... Chris

[Former Member]

Hi Arnd, thanks for your answer.

I have one more question: Why PB12.6 can compile and create 64 bit applications?
There is no way to use the 64 bit client with .exe?

Thank you very much

Luca Militello

[arnd_schmidt]

PowerBuilder IDE is 32-bit and needs the 32 bit Instant client.

HTH

Arnd