I am currently working with a Visual Basic 6 application and an 8.1.7 Oracle
database. How do you change an expired password from Visual Basic to Oracle?
Oracle returns the "expired password" error to VB6, but I can not find any
documentation on how to update the expired password.
In other languages this done through the connection object, which usually
has a property that can be set to update the password, while verifying the
userid and old password.
Thanks
Patrick
Ralph - 27 Jul 2005 21:16 GMT
> I am currently working with a Visual Basic 6 application and an 8.1.7 Oracle
> database. How do you change an expired password from Visual Basic to Oracle?
[quoted text clipped - 8 lines]
>
> Patrick
I don't have access to the manual at the moment, but I believe this can be
done thru the OO4O library. I have never tried it using ADO or DAO.
hth
-ralph
PJF - 27 Jul 2005 22:56 GMT
Thanks. I forgot about oo4o, I was able to change the password using it.
> > I am currently working with a Visual Basic 6 application and an 8.1.7
> Oracle
[quoted text clipped - 17 lines]
> hth
> -ralph
Paul Clement - 29 Jul 2005 18:00 GMT
¤ I am currently working with a Visual Basic 6 application and an 8.1.7 Oracle
¤ database. How do you change an expired password from Visual Basic to Oracle?
¤ Oracle returns the "expired password" error to VB6, but I can not find any
¤ documentation on how to update the expired password.
¤
¤ In other languages this done through the connection object, which usually
¤ has a property that can be set to update the password, while verifying the
¤ userid and old password.
Changing an expired Oracle password is integrated functionality. For example, if you're using SQL
Plus you will get a change password dialog when logging in with an expired password.
I don't believe this can be accomplished via ADO or any of the other Microsoft data access
mechanisms.
Paul
~~~~
Microsoft MVP (Visual Basic)