Re: Assistance with changing Oracle Password via ASP

From: Niall Litchfield <niall.litchfield_at_doial.pipex.com>
Date: 2000/06/24
Message-ID: <8j23hh$dm7$1@soap.pipex.net>#1/1

I'm not sure why your IIS is hanging but as the previous responses have said ALTER USER does not return a recordset so the line

rsPassChange.Open cmdTemp, , 1, 3, 1

makes no sense, and is probably the culprit

try

objConn.execute ....

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"lbj" <lyndonjohnson_at_execpc.com> wrote in message
news:395105de$0$28567$39368dfe_at_news.twtelecom.net...


> Then why is this command causing my IIS to hang......

> ?

>

>

> "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 Sat Jun 24 2000 - 00:00:00 CDT