This question is about the Password Expiration Dialog Box in Oracle and I am using PB2022 R2 (Build 2828)
In PowerBuilder (PB) with the parameter:
SQLCA.DBParm = "PWDialog=1"
If the User's Password expired, PB will display:
Whereas PowerServer (PS) display nothing!
I put the MessageBox after the Connection Using SQLCA in the code
SQLCA.DBParm = "PWDialog=1"
CONNECT USING SQLCA;
// check for database connection info
MessageBox('Connection Info', 'Code:' + String(SQLCA.SQLDBCODE) + CHAR(13) + CHAR(10) + 'Message:' + SQLCA.SQLERRText )
And in PS display:
The SQLDBCODE is: -1
But in PB:
The SQLDBCODE is: 28001 plus the Password Expiration Dialog Box is display.
This is bad in PS because User with expired Password cannot do anything unless someone else login successful to correct it.
Can someone help?
Thanks