Re: No response from oracle adodb call that updates User Password via an Alter User Command.

lbj heeft geschreven in bericht
<394550c2$2$28612$39368dfe_at_news.twtelecom.net>...
>I have coded an asp module that allows a user to change their password.
>It is called by another module that passes the Userid and Passwords. I am
>running into a problem where the code works 4 times consecutively and hangs
>on the subsequent fifth run.
 

> Set cmdTemp = Server.CreateObject("ADODB.Command")
> Set rsPassChange = Server.CreateObject("ADODB.Recordset")
> cmdTemp.CommandText = "ALTER USER " & strUserId & " IDENTIFIED BY " &
>strNewPass & ""
> cmdTemp.CommandType = 1
> Set cmdTemp.ActiveConnection = objConn
> rsPassChange.Open cmdTemp, , 1, 3, 1
> If Err.Number <> 0 Then
> Session("strMessage") = "Your new password was invalid - please try
 a
>different password." & _
> " Contact your account coordinator at M&I Data Services if you
>continue to experience problems."

Why not just do a
  objConn.Execute "ALTER USER " & strUserId & " IDENTIFIED BY " & strNewPass   If Err.Number <> 0 Then etc
Maybe simplicity works better, don't know, give it a try.

---
Peter Zaal
(remove the ~ from my mail address, sorry)