• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PowerBuilder 2019 connection to Oracle 19 using Kerberos Authentication

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

Resolved PowerBuilder 2019 connection to Oracle 19 using Kerberos Authentication

  1. How-to
0
Votes
Undo
  1. Aaron Lawes
    Aaron Lawes
  2. PowerBuilder
  3. Friday, 20 August 2021 20:59 PM UTC

We would like to implement Single Sign On with PowerBuilder 2019 R2 and Oracle 19.  Does anyone have specific examples on what values should be specified in SQLCA in order to use Kerberos authentication?

 

Consuming Webservice/ LDAP Login in PB 12.5 Classi...
Plan for fixing accessibility issues in 2019 R3 ?
Responses (1)
Tobias Bruegging
Tobias Bruegging Accepted Answer Pending Moderation
  1. Wednesday, 25 August 2021 06:36 AM UTC
  2. PowerBuilder
  3. # 1

Hi Aaron,

in a proof of concept I had success leaving LogID and LogPass empty to get a database login with the windows user. This may be related to the way our oracle client is configured...

Did you have success? Can you give me some hints to make it work better? My proof of concept should work as good as possible...

thx

Tobias

Comment
Tobias Bruegging
  1. Tobias Bruegging
  2. Wednesday, 25 August 2021 06:39 AM UTC
You were asking for code:



SQLCA.DBMS = "ORA Oracle"

SQLCA.ServerName = "tnsname of database"

SQLCA.AutoCommit = False



CONNECT USING SQLCA;



//Your error handling here... ;-)
  1. Helpful 1
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.