Help? How to use ASP with alter user command.

[ttheobal]

I'm not sure whether this post should be in the ASP section or Oracle. I guess my question is with ASP, but it's Oracle that I'm connecting to.

I am working on a html (asp) doc that receives username and password info from a form, then connects to oracle and issues an alter command to update the password.

I got the connection to oracle to work, but My alter command doesn't work. No errors are reported either. I've attached my code below.

On Error Resume Next
objSQL = Server.CreateObject("ADODB.Command&quot
set objSQL.ActiveConnection = objConn
StrCommand = "alter user " & Userid & " identified by """ & NewPassword & """;"
objSQL.execute StrCommand
If objSQL.errors.count > 0 then
Response.write( objSQL.errors.count & &quot;Errors Occured while setting password&quot; & &quot;<P>&quot
Response.write objSQL.errors.count
For counter= 0 to objSQL.errors.count
Response.write(&quot;Error #&quot; & objSQL.errors(counter).number & &quot;<P>&quot
Response.write(&quot;Error desc. -> &quot; & objSQL.errors(counter).description & &quot;<P>&quot
Next
else
response.write(&quot;nO ERRORS&quot
end if

Any help is greatly appreciated.