Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Visual Foxpro for a database on a web site?????
Message
From
23/01/2001 11:43:19
 
 
To
22/01/2001 16:19:55
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Internet
Category:
Active Server Page
Miscellaneous
Thread ID:
00457797
Message ID:
00467372
Views:
20
> 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.
Phil
_____________________________
Phil Miles
http://www.philmiles.com
phil@philmiles.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform