PowerBuilder 2019 connection to Oracle 19 using Kerberos Authentication

Resolved PowerBuilder 2019 connection to Oracle 19 using Kerberos Authentication

How-to

Votes

Undo

Aaron Lawes
PowerBuilder
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?

Responses (1)

Tobias Bruegging Accepted Answer Pending Moderation

Wednesday, 25 August 2021 06:36 AM UTC
PowerBuilder
# 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
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... ;-)

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.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

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.