1. Karthik Manoharan
  2. PowerBuilder
  3. Friday, 8 May 2020 12:43 PM UTC

Hi Team,

In Our project we are using Powerbuilder 10.5 version and backend as Oracle 11g.

Now our client wants to migrate the backend from Oracle 11g to Oracle 12c or Oracle 19c. We were analysed the migration from Oracle 11g to higher version of Oracle(12c or 19c) from multiple sources like SAP and your websites.

But we didnt get the exact details which we want.

Could you please give the details for the below items,

1)Whethere the PowerBuildet 10.5 will support Oracle 12c or 19c.

2)If it possible please share how to connect the Oracle 12c or 19c in PB 10.5

Karthik Manoharan Accepted Answer Pending Moderation
  1. Tuesday, 12 May 2020 05:12 AM UTC
  2. PowerBuilder
  3. # 1

So, Official support for PB10.5 is Oracle 10g.

We can connect 11g, 12c or 19c server by using 10g client in Powerbuilder 10.5v

But we cannot use any features availabel on 11g, 12 and 19c releases.

 

Is that correct ?

And this is not official one ?

 

Comment
  1. Armeen Mazda @Appeon
  2. Tuesday, 12 May 2020 05:25 AM UTC
If you want to use Oracle 19c you should not be using database driver or version of PowerBuilder from 14 years ago! Whoever tell you otherwise doesn’t have their ass on the line for your system reliability.
  1. Helpful
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 8 May 2020 19:23 PM UTC
  2. PowerBuilder
  3. # 2

Update:  11-MAY-2020
   I have connected to Oracle 12C from PBv12.x with no issues.
   I have connected to Oracle 11g from PBv10.5 with no issues.

Olan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Karthik -

   I have connected to Oracle 11g from PBv10.5 with no issues.   (not 12C as previously listed.)
   I have clients who have connected to Oracle 19 with PBv10 code.

   Caveat #1:  I do not use any of the Oracle version-specific featurs or functions, I just use the basic RDBMS functions.

   Caveat #2:  Oracle is stupid expensive, but the 12C license is FAR FAR FAR less expensive than the 19 license. If you do not need version-specific features, stick with 12C.


Later -

OPlan

Comment
  1. Karthik Manoharan
  2. Monday, 11 May 2020 04:19 AM UTC
Thank you for your valuable inputs
  1. Helpful
  1. Karthik Manoharan
  2. Monday, 11 May 2020 04:22 AM UTC
Hi Olan,

In PowerBuilder 10.5v we dont have Oracle12c database interface.

Could you please share the that information with me so that it ll be helpfull for us.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 11 May 2020 05:00 AM UTC
Hi Karthik;

You cannot connect to O12c/18c/19C from PB 10.x as these DBMS are not supported by that PB release. You would have to use a *much* lower DB client version that does not support the newer Oracle release. While you can try this, it's not officially supported by Oracle. However, you may go this route "at your own risk".

Regards ... Chris
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 8 May 2020 15:23 PM UTC
  2. PowerBuilder
  3. # 3

PowerBuilder connects to Oracle Client installed locally, not the server directly. As long as you have a version of Oracle Client that works with PB 10.5 and it can connect to the database server, you will be able to connect from PB.

You won't be able to use any datatypes or functions that were added to the server after the version of OC that you are using.

Comment
  1. Karthik Manoharan
  2. Monday, 11 May 2020 04:23 AM UTC
Thank you for the input.
  1. Helpful
  1. Roland Smith
  2. Monday, 11 May 2020 20:38 PM UTC
The most recent Oracle Client supported by PB 10.5 is 10G.I don't know if the 10G client can connect to the latest versions, probably not. You might be able to get an ODBC connection to work but you would still be limited to datatypes and functions that existed in 10G or earlier.

You should be thinking about migrating to PowerBuilder 2019 as 10.5 is over 10 years old.
  1. Helpful
There are no comments made yet.
Michael Kramer Accepted Answer Pending Moderation
  1. Friday, 8 May 2020 13:52 PM UTC
  2. PowerBuilder
  3. # 4

No support of Oracle 12c or newer in PowerBuilder 10.5.

Even PowerBuilder 12.5 several years younger than PB 10.5 has no official support of Oracle 12g.

Comment
  1. Karthik Manoharan
  2. Monday, 11 May 2020 04:24 AM UTC
Thank you for the inputs
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Friday, 8 May 2020 13:47 PM UTC
  2. PowerBuilder
  3. # 5

Greetings, Karthik - 

PB 10.5 was released in early 2006, I believe. According to the PB 10.5 documentation, the latest version of Oracle it officially supported was 10g. Your hope or expectation of finding a way to interface PB 10.5 with Oracle 12c or higher is not realistic. Also consider: PB 10.5 is not certified for use on current versions of Windows and Windows Server.

Oracle 12c support was added by Appeon in PB 2017. Support for Oracle 19c was added to PB in version 2019 Release 2 (the latest release).

If you need to interface with a contemporary DBMS, you'll need to migrate off of a development platform that is now 14 years old.

Regards, John

Comment
  1. Karthik Manoharan
  2. Monday, 11 May 2020 04:24 AM UTC
Thank you so much for your valuable inputs
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.