davesil2 Posted November 26, 2003 Posted November 26, 2003 I'm working with foxpro tables to write an asp.net page (same as vb.net for the most part). I am having trouble writing to the foxpro dbf file. I am using the foxpro driver from microsoft and reading works fine. However when I try to "update" information (whether adding a record or updating or deleting) I errors back at me about the cursor. da.update(ds,"time") is the code i'm using da.fill(ds, "time") works fine in the asp and I can pull data out after adding a new row I call the update command and it spits back the cursor error "OleDbException (0x80004005): Cannot update the cursor TIME, since it is read-only" I am using the ole objects to connect and I don't know if that's the problem or what. If someone has any info, please let me know -Thanks David Quote
TAVALSS Posted January 15, 2004 Posted January 15, 2004 Having same problem. I changed the connection string mode property to "Mode = ReadWrite", but same problem occurs. Hope someone has some ideas... Quote
TAVALSS Posted January 15, 2004 Posted January 15, 2004 go here for the solution: http://www.mcse.ms/message122542.html Make sure that the main folder and all sub-folders have the right permissions... I changed the sharing/security options and the "read only cursor" problem went away. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.