Hello

I have written some basic ASP code to update or the delete the existing record in my database. The code seems to work fine on my desktop with IIS but it doesn't work on the server or on my laptop and gives me the following error for deleting

Microsoft OLE DB Provider for ODBC Drivers (0x80004005), could not delete from specified tables for

and this error for updating:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005),operation must use an updatable query.

Does anyone have any ideas why this may happen, it does work perfectly fine on one machine but not on others :(

Thanks

do you sql statements or ADO objects?

I use SQL statements such as the following for editing:

targetString = "UPDATE cvtable SET Name = '$name', Surname='$surname', Gender='$gender', Cvtext = '$cvtext' WHERE ID=$id"

targetString = replace(targetString, "$name", request.form("Name"))

targetString = replace(targetString, "$surname", request.form("Surname"))

targetString = replace(targetString, "$gender", request.form("Gender"))

targetString = replace(targetString, "$cvtext", request.form("cvtext"))

targetString = replace(targetString, "$id", request.form("ID"))

conn.execute targetString

and this one for deleting:

Conn.execute "DELETE * FROM cvtable WHERE ID= " & cv_id

What would be the difference between using SQL or ADO and which one is more beneficial?

Thanks

Dear i was also facing the same prob with the web host.The solution was that where i was keeping me database that folder was read only at the server.so i changed the folder and now it is ok. You may check it also perhapes it may work for you too.

I THINK THIS IS BECUSE THE DIRECTORY ON YOUR SERVER IN WHICH YOU KEEP YOUR DATABASE DOSENT HAVE WRITE PERMISSION ASSIGN WRITE PERMISSION TO THAT DIRECTORY. OR ASK YOUR WEB ADMINISTRATOR TO DO SO


dinesh rana

dinesh Rana