Password Change Dlg in OraOleDB

Hi,

I am using VB.NET code with OraOLEDB provider to logon to Oracle 10g database.
In the connection string I have used PwdChgDlg=1 option.

When password expires oracle pops up Change password dialog, but after supplying
Old password, New password and Retype New password I'm getting
Ora-00988: Missing or Invalid password(s) error.

Request anyone of you to help me in this regards.

Thanks in Advance.
mdasifsAsked:
Who is Participating?
 
POracleConnect With a Mentor Commented:
There are 3 text box in your dialog box...

First textbox require Current password
and other 2 textbox require new password.

Case:-1
If you give wrong password in first textbox it may give error invalid password. Are you sure you are passing correct password here.

Case:2
Read Manual of Oracle for possible password and allowed character combination. Follow rule for new password.

 
0
 
elimesikaCommented:
Your password is probably not valid.

If the password is not enclosed in quotes then it can include any letter, any digit "_ " "# " or "$ " characters. Only a letter can be used in the first character.

Please try to provide a password according to that and retry.
0
 
mdasifsAuthor Commented:
Thanks elimesika ..

But I'm entering password in OraOleDB Provider provided dialog box, do i need to include quotes in that dialog box? I am not using Alter user command .. to change password

When you include PwdChgDlg=1 in connection string you will get Oracle Ole provided dialog box on Password expiry.

Thanks
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
elimesikaCommented:
and what is the password that you are trying to enter ??
0
 
ajexpertCommented:
Is your password starting with number?

This  link might help.  Start reading from "Re: procedure to change password [message #426160 is a reply to message #426159]"

http://www.orafaq.com/forum/t/150992/2/

HTH
0
 
POracleCommented:
test with password= expert

Let us know whether this password works or not?
0
 
mdasifsAuthor Commented:
it doesn't work.. getting the same error Ora-00988: Missing or Invalid password(s) error.
0
 
DavidSenior Oracle Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.