New oracle database with pb 12.5.2 classic

[Former Member]

I have a client that's upgrading to oracle 12c

Does anyone know of any issues with that?

Most of the time.. when working with newer databases, people use the same oracle client.

Like... I use 11.2 version of the oracle client.

I'm assuming there is a version 12 of the oracle client as well.

Is there any issues with using the newest client?

I know... that when we went to 12.1.... the user had to be using, at least version 9i or above

that's what we were told, anyway

[former_member190719]

You should be fine.  The reason you had to be on 9 or later of the client is because there were major changes in the way the client worked between 8 and 9.

[Former Member]

So... does the powerbuilder application just use the pb version of the driver files to talk to the database?

I've always assumed that you have to install the oracle client, on the machine.

Do the powerbuilder drivers talk to the oracle client, or directly to the database?

if it talks to the oracle client... Do we need to make sure we install Version 11 of the oracle client?

or...  does it just use the oracle client, for tnsnames purposes?

Just trying to understand, how the application talks to the database

Is it direct... or, thru the oracle client

[CobyKako]

Hello Scot,

Sometimes a picture is easier to understand than a set of sentences :

From documentation: Basic software components for Oracle

HTH

Jacob

[Former Member]

All PB's "native" drivers for any DBMS are actually only "interfaces" to the real DB Client software supplied by your DBMS vendor.

Drivers like ADO, OLE-DB & ODBC are really only interfaces to "Middleware", which in turn may/may not load the DBMS client, which in turn talks to the real DBMS.

[Former Member]

Hi Scott;

  If you want to use the O12 client - you will need to upgrade to PB 12.6. However, you should be able to use your lower level client with PB 12.5.x and O12. You just won't be able to use any new O12 features as you will be restricted to the O11G feature set.

Regards ... Chris

[Former Member]

we usually set the dbms in the ini file

[database]

Vendors=Oracle

DBMS=O10

are you saying that we could only use, up to DBMS=O11

Here's where I've been a bit confused

The oracle client has to be installed... but, powerbuilder seems to have some of it's own

files that are related to the database / level

Do the powerbuilder drivers talk to the database directly?

or... are they used in combination to the installed oracle client?

If they oracle 12c is installed on the machine... can we set the DBMS=O11

and, still have 12.5.2 work?

[Former Member]

Correct, you could only use the O11 setting in PB 12.5.x and yes, that should load the O11 client that in turn would communicate with O12C. That should work AFAIK.