Re: Assistance with changing Oracle Password via ASP

Don't use a command or recordset for this. Just a call to objConn.Execute. Like:
  objConn.Execute "ALTER USER..."

To be able to run this command, the logged on user needs to be able to change the password for the specified user.

-C

"lbj" <lyndonjohnson_at_execpc.com> wrote in message news:394fd17e$1$156$39368dfe_at_news.twtelecom.net...
> This command hangs the web server:
>
> 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
>
>
> Is there another way of changing the password?
>
>
Received on Wed Jun 21 2000 - 00:00:00 CDT