Ed (& Phil)...

I am going to pass this on to the techs at the web host and see what they think and if this is the issue. So
my code looks ok at first glances then right? Does it matter if it is DNS vs DNSless? I found out I can
get them (for a fee) to configure the DNS for the database. You think that might fix the perm problem?

Thanks

Pete

>There are 2 IUSR_ accounts, the 2nd one is used for what you are
>referring to, not the standard IUSR_ account. It is very likely
>the 2nd IWAM_MACHINE account does not have write permissions to the data folder.
>
>This is the user that is impersonated for each thread that fires off of ASP, once you add this user with write permissions to the data folder, the error should go away. By default it is getting in there through the 'everyone' ACL with read permission.
>
>I have to deal with that problem on new machines often..
>
>HTH,
>Ed
>
>
>>> Phil,
>>>
>>>Well I'M BACK!!!!! Actually, I finally got the permission thing checked at the company serving the site. I
>>>just got off the phone with them and they verify that on the NT server, the "data" folder is set for READ/WRITE
>>>and all 10 files in the folder are currently set for READ/WRITE. They verified the IUSER information is all set
>>>appropriately.
>>>
>>>Here is what I am getting when I try to delete from the file:
>>>=========================
>>>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>>>
>>>[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
>>>
>>>/new/userdel.asp, line 18
>>>=========================
>>>
>>>Here is the code:
>>>=========================
>>> @LANGUAGE="VBSCRIPT"
>>>#include file="adovbs.inc"
>>>
>>>
>>>if request("p_del").count > 0 then
>>> dim DBmiym
>>> dim DBpath
>>> set DBmiym=server.createobject("adodb.connection")
>>> DBpath="sourceDB=" & server.mappath("../data")
>>> DBmiym.Open "DRIVER={Microsoft Visual FoxPro Driver}; SourceType=DBF; " & DBpath & "; Exclusive=No"
>>>
>>> set userSet=server.createobject("ADODB.RecordSet")
>>> userSet.Open "select * from user",DBmiym,1,3,adCmdText
>>>
>>> for each p_del in request("p_del")
>>> userset.find "userid='" & trim(p_del) & "'"
>>> userset.delete
>>> next
>>>
>>> UserSet.close
>>> set userset=Nothing
>>> DBmiym.close
>>> set DBmiym=Nothing
>>>end if
>>>response.redirect "./userlist.asp"
>>>
>>>=================================
>>>I can open, search, and display information from the files without a problem. If I try to delete, as above,
>>>I get the error. I checked to make sure I was finding the right record by removing the delete clause and
>>>response.write the info out. That is correct.
>>>
>>>On other pages that access the DB, if I try to UPDATE (like making a correction) or ADDNEW (such as
>>>adding a new record) or using an SQL insert all get the same error.
>>>
>>>
>>>HELP!!!! What am I missing? If this is a permission problem - what do I need to tell them at the hosting
>>>company because it appears it is correct
>>>
>>>Thanks
>>>
>>>Pete
>>>
>>
>>Hi Pete,
>>
>>Bizarre! I will try to recreate your problem by mimicing your script. I cannot explain the problem. I will do it tonight.