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

From: lbj <lyndonjohnson_at_execpc.com>
Date: 2000/06/23
Message-ID: <39539225$0$155$39368dfe@news.twtelecom.net>#1/1

Solution: Use Microsoft Oracle drivers versus the Oracle Drivers(7.3..x) for ADODB calls......

Thank Everyone...

"Peter Zaal" <pzaal~@xs4all.nl> wrote in message news:8i6abi$b65$1_at_news1.xs4all.nl...
> 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)

>
>
>

Received on Fri Jun 23 2000 - 00:00:00 CDT