1. santosh kale
  2. PowerBuilder
  3. Thursday, 21 February 2019 08:39 AM UTC

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
  1. Monday, 25 February 2019 02:49 AM UTC
  2. PowerBuilder
  3. # 1

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.
Bruce Armstrong Accepted Answer Pending Moderation
  1. Thursday, 21 February 2019 14:58 PM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


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