1. Nasir Khan
  2. PowerBuilder
  3. Friday, 15 September 2017 03:25 AM UTC

Hi All,

I have just installed Powerbuilder 2017, and am having some difficulty connecting to an Oracle 12c database.

When I go to DB Profile, I only get options for Oracle 9i, Oracle 10g and ORA.
When I attempt to create a profile using ORA, I get the error "Oracle 11g or higher client is not installed or not set to Primary Oracle Home."

Have I missed anything? Should I have an option for Oracle 12 in my list Database Profiles screen?

Thanks,
Nas

Olan Knight Accepted Answer Pending Moderation
  1. Friday, 15 September 2017 23:44 PM UTC
  2. PowerBuilder
  3. # 1

The list of "Installed database interfaces" in the Database Painter of the PowerBuilder IDE was determined by the options you specified during the installation of your PowerBuilder IDE.

If PB2017 has "Oracle 12" listed as one of the options, you can re-install PowerBuider and select that option.

If not, you must use the Oracle 10 or Oracle 11 interface.

Please note that this WILL work; you WILL be able to connect to the Oracle 12 database, but you will not have access to any of the Oracle 12 specific capabilities.

 

Personally, I am connecting to an Oracle 12 database using the Oracle 10 interface, and it works just fine!

 

Later -

Olan

Comment
There are no comments made yet.
Appeon Support Team Accepted Answer Pending Moderation
  1. Friday, 15 September 2017 07:48 AM UTC
  2. PowerBuilder
  3. # 2

Hi,

Please make sure you had installed 32-bit Oracle 12c client on this machine.

Regards,
Zhaokai

Comment
  1. David Peace (Powersoft)
  2. Friday, 15 September 2017 11:07 AM UTC
Can you connect to Oracle from outside of PB, try using TNSPING to test your connection first. Also the point about the 32-bit version of the client installation is very important.

  1. Helpful
There are no comments made yet.
René Ullrich Accepted Answer Pending Moderation
  1. Friday, 15 September 2017 06:26 AM UTC
  2. PowerBuilder
  3. # 3

There will be no option for Oracle 12. For Oracle 11 and 12 use "ORA".

The version you have to use depends from installed Oracle client, not from Oracle server!

Comment
  1. Nasir Khan
  2. Tuesday, 19 September 2017 03:19 AM UTC
I installed Oracle client, and also used the ORA option when setting up the DB Profile.



Its working now. I appreciate every ones assistance.

Thanks All. 

  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.