I cannot use neither UPDATE nor INSERT commands in ASP.NET
(on Windows 2003 !!!!)
application which use FoxPro database. When I try update
table, then I get error:

"Cannot update the cursor. Table <table> since it is read-
only"

[quoted text, click to view]
into Fox DB.

I tried MS example which is described in title:
- "Using ASP.NET in Visual Studio .NET with Visual
FoxPro 7.0"
- Example 1: Accessing Visual FoxPro Data Using OLE
DB


IT ISN'T FUNCTIONAL !!!
There is problem propably on Windows 2003 server and IIS,
because same example is functional on other system.

Hi Jan,

It is true that a Windows App may work trying to Modify data on a file based database such as FoxPro, Access, Excel, etc and fails when using the same code from within an
ASP or ASP.NET application. The reason is that in Windows App there is no permissions required to file resources, however in ASP or ASP.NET everything has go through
IIS and the account used must have the proper permissions.

It looks like the ASPNET account used on the Windows 2003 computer doesn't have Write/Modify permissions on the folder where the FoxPro table resides. To verify that it
is a permissions issue, use the Windows Explorer and check the Properties of the folder then click on the Security tab. There you should see all the accounts permitted and
their level of access. Just add the EveryOne group and try your application. If it works, then it is a lack of write permissions on that folder. You may then remove that group
and just add the ASPNET and give it "full control". If your IIS is configured to use another account then add that account as I indicated above.

I hope this helps!


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.