1. santosh kale
  2. PowerBuilder
  3. Thursday, 21 February 2019

I am trying to connect 12c database  through PowerBuilder 2017 R3

with following code 

if not IsValid (SQLADM) then
SQLADM = create n_tr
end if


ls_logon_user_prefix = this.of_prefix(as_userid)

SQLADM.of_Init(is_AppINIFile, "Database")
SQLADM.logid = ls_logon_user_prefix
SQLADM.logpass = ls_encrypt_passwd

IF SQLADM.of_Connect() <> 0 THEN
ls_encrypt_passwd = this.of_encryption_old(0, this.is_userseed, as_password) // 0 - encrypt
ls_encrypt_passwd = this.of_prefix(ls_encrypt_passwd) // add prefix if required
SQLADM.logpass = ls_encrypt_passwd
IF SQLADM.of_Connect() <> 0 THEN
MessageBox('Error Msg', SQLADM.SQLErrText)
return -1
end if

getting the following message

ORA-01017: invalid username/password; logon denied

But Same code if I try to connect to oracle 11g database its working perfectly fine.

Thanks 

Santosh Kale

 

santosh kale Accepted Answer Pending Moderation
0
Votes
Undo

Bruce, Thanks for your reply

Here is the new findings issue

For Oracle 11g , I can pass encrypted password to connect the database 

SQLADM.logpass = ls_encrypt_passwd

whereas 

For Oracle 12c I cannot pass encrypted password to connect to database, but if I pass decrypted password then able to connect.

How to resolve this issue, I need to connect to 12c database with encrypted password

Thanks

Santosh kale

Comment
There are no comments made yet.
  1. Monday, 25 February 2019
  2. PowerBuilder
  3. # 1
Bruce Armstrong Accepted Answer Pending Moderation
1
Votes
Undo

Oracle 12 introduced case sensitive passwords.  Chances are that you're sending the password in a case different than what the database is expecting now.

https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/case-insensitive-passwords-ora-1017-invalid-username-password.html#GUID-FDA9C77A-12F4-4410-9448-9BCC13960C27

 

Comment
There are no comments made yet.
  1. Thursday, 21 February 2019
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.