Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE DB Read-Only problem
Message
 
To
23/02/2004 20:53:32
Larry Long
ProgRes (Programming Resources)
Georgia, United States
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00880142
Message ID:
00880150
Views:
20
Larry,

>I created VFP tables for security (based on your structure) and have them on a local drive. Using OLEDB for VFP, I have the connection set up as ReadWrite|Share Deny None, but get an error saying that it is read only when I try to add into (Roles in this case) Do I need to set up additional security sharing access for .Net? If so, what "user" is the .Net user?

Larry, I recently added the following topic to the MM .NET Dev Guide that will appear in the next release:
When using the INSERT or UPDATE commands from within an ASP.NET application that access VFP data, you may get
the error "Cannot update the cursor <Table Name>, since it is read-only." This is probably due to a lack of 
permissions.

To fix this problem, you need to specify rights for your ASP.NET user account (usually ASPNET) to have read/write
access to that particular directory as outlined in these steps:

1. In Windows Explorer, right-click the folder that contains the VFP data, and select Properties from the shortcut menu.

2. In the Properties dialog, select the Security tab.

3. Click the Add button to add the ASPNET (or other user) to the list of users.

4. In the Select Users or Groups dialog, enter ASPNET in the text box. 

3. Click the Check Names button, which may add a machine name prefix to the user name

5. Click OK to add the new user

6. In the Properties dialog, select the new user in the list, and select the 
Full Control check box to give full rights to the user.

7. Click OK to save changes
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform