1. 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?

 

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
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.