Re: Assistance with changing Oracle Password via ASP

From: Stefan Falz <ms.news_at_asp-database.de>
Date: 2000/06/21
Message-ID: <OEr6Xu22$GA.269@cppssbbsa04>#1/1

Hello,

Set objConn = Server.CreateObject("ADODB.Connection")

    objConn.Open DSN, User, Password

        strSQL = "ALTER USER " & strUserId & " IDENTIFIED BY " & strNewPass
        objConn.Execute strSQL

    objConn.Close
Set objConn = Nothing

On Oracle 7.34 this works.

Bye, Stefan
http://www.asp-database.de

lbj <lyndonjohnson_at_execpc.com> schrieb in im Newsbeitrag: 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