Does PB 12.6 Support Oracle 12c Driver?

[Former Member]

Good day!

Looking at the PB 12.6 Classic Help, it seems that 12.6 does not support Oracle 12c, or at least, the Oracle 12c driver.

I can connect if I specify SQLCA.DBMS = 'ORA', but that's the 11g driver.

Any ideas? I have clients who will be implementing 12c and I do not want to tell them to install the 11g client.

Thanks,

Tom

[Former Member · Accepted solution]

Yes - PBORA126.dll is the Oracle 12c driver.

Support for Using PowerBuilder and Oracle - SAP PowerBuilder - SCN Wiki

-Paul-

[Former Member · Accepted solution]

Thanks, Paul. I saw that link, too, but the PB 12.6 Help reads: ORA Oracle 11g PBORA126.DLL

What value should I put in SQLCA.DBMS? If I put 'ORA' isn't that 11g? What do I put for 12c?

[Former Member · Accepted solution]

The first three characters of sqlca.DBMS matches position 3 - 5 of the driver file. For 12.6 you would use 'ORA' to use PBORA126.DLL.

Previous versions of PowerBuilder had Oracle version specific drivers, O10 for example. Newer versions introduced a generic ORA driver that can work with multiple versions of Oracle.

[Former Member]

Hi Tom;

  While the PB Help states only 11G supported yet the link Paul provided states 12c. Its interesting to note though that there is only 24 bytes difference between PB 12.5.x and 12.6's PBORAxxx.dll.

  My suspicion is that PB 12.6 will work with the 12c client - but, still only supports the 11G functionality.

  When you connect and do some testing with 12c - please let us know your progress & findings.

Regards ... Chris