IIS 5 & IIS 6
AJAX Toolkit: writing to Access DB is not working on IIS6 + WinServer...
Last post Oct 16, 2013 07:03 AM by Terry Guo - MSFT
Oct 15, 2013 09:37 AM|caop|LINK
Parts of our app is using ReoderList control of AJAX Toolkit to rearrange priorities of projects.
Database is MS Access .mdb created with Access 2010 Pro , .Net Framework is 4.0.3019 and the Provider is Jet OLE DB 4.0
It runs perfectly on the development machine under Win 7 + IIS 7, that is, reordering is done (drag and drop of an item) and then auto-postback reflects the new situation in the DB.
When published on the prod server Win 2003 Server + IIS6, reading from the database works as expected. Reordering seems to work in the control but the database is not updated. PostBack brings back the original ordering.
I supected access rights on the server but temporarily setting Full control to all users on the App_Data folder didn't change anything.
I also updated the drivers to use ACE.OleDb.12.0 on a .accdb version of the database. To no avail...
The IIS logs just show Success 200 for the GET (displaying the page) and the POST (PostBack after reorder).
The database file is untouched (no last accessed date/time change).
I inspected the Event log and couldn't see anything relevant.
There is no error message of any sort. It just doesn't write to the DB.
Parts of the app that are writen in "classic" asp do write normally.
So now I see no way to progress. I'm sur I'm missing something but where to look at ?
Is there any flag that could be raised somewhere to get more debug information ?
Thank you for any idea that could help.
Oct 16, 2013 07:03 AM|Terry Guo - MSFT|LINK
Hi, According to your description, my guess is there no set write permissions to database file. Please try to refer to the following steps to set the write permissions:
1. Right click on the directory containing the database or text file.
2. Click on "Properties". A new Option window will open as shown below.
3. Choose the "Security" tab form on the dialog box window.
(Uncheck 'Allow inheritable permissions from parent to propagate to this object', from the bottom of the dialog box, if the checkbox is available in your system.)
4. Next, click on the "Add..." button.
5. A new option Window will popup. Now click "Advanced" and then "Find now"
6. Look for IUSR_XXX (e.g. IUSR_yourMachineName) and double click it.
7. You will see again a window as shown below. Click "OK".
8. So here comes the final step.
Depending on what Permissions you want to give your Internet Guest account (IUSR) check the checkboxes next to each option. - If you want them to only access and Read a file check only the option "READ". - If you want them to Insert data in addition
to read then check the option "Read" and "Write". - If you also want them to modify the data in the File (which is mostly the case) then check the option "Modify". 9. Now the IUSR_XXX have the write permission.
Hope it can help you.