Hello,
I am using VB6/ADO connecting to oracle 8 via odbc. I have to deal with the
password expiration feature of oracle and I have to solve 2 problems:
- while a users password has not yet expired (but is in grace period),
oracle shows this message: ORA-28002: the password will expire within num
days. When logging in with SQLPlus, I can see this message. But how can I
get this message back into VB when doing the login with ADO?
As far as I tried, I can process the errors collection of the connection
object, but in this case, it is filled with only 1 error, which is:
<ADO connection>.Errors.SQLState=IM006
<ADO connection>.Errors.Number=0
<ADO connection>.Errors.NativeError=0
<ADO connection>.Errors.Description=[Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed
<ADO connection>.Errors.Source=Microsoft OLE DB Provider for ODBC Drivers
- after a users password has expired, login is no longer possible. In this
case, VB produces an error (ORA-28001: the password has expired) which is
correct. (Also, the error collection of the connection object contains this
error.)
Is there a way for the user to change (only change, nothing else) his
password? Or is the only chance to contact the DB administrator?
Thanks for any help.
Daniel Marthaler
E-Mail: dmarthaler_at_swissonline.ch
Received on Thu Aug 12 1999 - 01:20:36 CDT
