Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsVB SyntaxEnterprise DevelopmentDatabase AccessControlsCOMWin APICrystal ReportDeploymentGeneralGeneral 2
Related Topics
VB.NET / ASP.NETMS SQL ServerMS AccessOther Database ProductsMore Topics ...

VB Forum / Database Access / July 2005



Tip: Looking for answers? Try searching our database.

Changing an expired password.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PJF - 27 Jul 2005 19:05 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.

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)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.