• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PowerBuilder connection to Oracle Express XE 18 failure

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved PowerBuilder connection to Oracle Express XE 18 failure

  1. Issue
0
Votes
Undo
  1. Randy Severance
    Randy Severance
  2. PowerBuilder
  3. Friday, 17 April 2020 17:04 PM UTC

I have an instance of "Oracle Express XE 18" loaded on a desktop.

Using this desktop -

I am able to connect to that XE with Oracle Developer, SQL+ and Toad - proving the validity of my tnsnames.ora and authentication protocols

I am NOT able to connect to that XE with PowerBuilder. When I attempt a connection I get error message: oerr ORA 28040 "No matching authentication protocol". PowerBuilder is able to connect to other external server resident Oracle databases, but not the local desktop resident Oracle Express XE.

Other likely pertinent information:

1. I have been using PowerBuilder for 20 years but recently upgrade to Appeon's version in order to migrate to Win10.
2. This is the first time PowerBuilder has been loaded on this particular desktop.
3. This is the first time I have tried to connect PowerBuilder to an Oracle Express instance

Is there some trick to connecting to an Oracle Express?

 

PB Documentation?
convert an image into hex Bitmap in PowerBuilder
Responses (4)
Randy Severance
Randy Severance Accepted Answer Pending Moderation
  1. Tuesday, 21 April 2020 13:07 PM UTC
  2. PowerBuilder
  3. # 1

After some more work I am now getting a different error:

Please connect as the PowerBuilder Catalog Owner. This is necessary for the initial connection to Oracle to GRANT provileges on the repository.

What/who is the PowerBuilder Catalog Owner. I am unfamiliar with that term.

 

Comment
Ken Guo @Appeon
  1. Ken Guo @Appeon
  2. Wednesday, 22 April 2020 02:39 AM UTC
Hi Randy，



Please click the System tab in the Database Profile Setup page, input your username in the PowerBuilder Catalog Table Owner field and then try again.

Please refer to the following links:

https://raccoon.ninja/en/dev/oracle-please-connect-as-the-powerbuilder-catalog-owner-2/

https://community.appeon.com/index.php/qna/q-a/resolved-database-script-question



Regards,

Ken

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 April 2020 18:11 PM UTC
  2. PowerBuilder
  3. # 2

Hi Randy;

  I am also using O18C Express on my PC's. After installing the O18C server, I then also installed the O18C client. After that, I had no problems connecting to O18C from either 2017R3 or PB2019.

Note: I am using the O18C "Instant Client" (my favourite).  ;-)

Tip: Install both the 32bit & 64bit client drivers as the IDE will require the 32bit O18C client but,  64bit App EXE's and PowerServer (O18C works great from there too) will require the 64bit one.  ;-)

HTH

Regards ... Chris

Comment
There are no comments made yet.
Randy Severance
Randy Severance Accepted Answer Pending Moderation
  1. Friday, 17 April 2020 17:43 PM UTC
  2. PowerBuilder
  3. # 3

I am using PowerBuilder 2019 2R

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 22 April 2020 15:23 PM UTC
Great!
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 April 2020 17:30 PM UTC
  2. PowerBuilder
  3. # 4

Are you using PowerBuilder 2019 R2 or PowerBuilder 2017 R3 MR 1915?  These are the only two versions of PowerBuilder that have been tested with and officially support Oracle 18/19.

Comment
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.