Skip to Content
avatar image
Former Member

POWER BUILDER 12.6 WITH 64 BIT ORACLE INSTANT CLIENT 12

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 30, 2016 at 02:22 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2016 at 12:43 PM

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

    HTH

    Arnd

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2016 at 01:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2016 at 01:56 PM

    Hi Luca;

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

    Regards ... Chris

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2016 at 02:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2016 at 02:36 PM

    Ok, thank you very much!

    Luca

    Add comment
    10|10000 characters needed characters exceeded