updata

bukky · February 25th, 2004, 03:53 PM

Kindly me with my update statment; it's giving me the following error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/BegASP/student1.asp, line 42

Here's the code:
% Response.Buffer = False %>

<html>
<head>
<Title>Passoword change website</title>
</head>
<body>
<h2>Password change response<h2>
<%

'Declare variable needed
Dim strSql
Dim adCmdText

adCmdText = 1

'Retrieve the values
varStudentID = Request.Form("StudentId")
varPassword = Request.Form("Password")
varNewpassword = Request.Form("NewPassword")

'start building sql statement
strSql = "Update ftpserver_users Set"
strSql = strSql & " Password ='" & varNewpassword & "'"
strSql = strSql & " WHERE ID =" & varStudentID
strSql = strSql & " AND Password='" & varPassword & "'"

'Create and Open connection to database
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.OPen "DSN=users"

'Create command object
Set objCmd = Server.CreateObject("ADODB.Command")

'Set Command Properties
Set objCmd.ActiveConnection = objConn
objCmd.CommandText = strSql
objCmd.CommandType = adCmdText

'Execute Command
objCmd.Execute

'Response.Write " Your passwords has been changed."
'Response.write " The number of record that has changed is: " & _
' intnumofrecord & " records<BR><BR>"

Set objCmd = Nothing
objConn.Close
Set objConn = Nothing

%>

</form>
</body>
</html>

Imar · February 25th, 2004, 04:09 PM

Hi there,

This error message usually indicates a permissions issue. Take a look here: http://support.microsoft.com/default...;en-us;q175168 (bullet 1) for more info.

To fix it, make sure that the account IIS runs under (usually IUSR_MachineName) has sufficient permissions to write to the database and the folder it resides in.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

bukky · February 27th, 2004, 02:42 PM

I have tried all the options I have, and it's not working.