Update works on WebMatrix but not IIS 5.1

[russgreen]

I have built a simple aspx page with Web Matrix 0.6. It use OLEDB to populate a editable datagrid from an access .mdb file. It is intended for use on and intranet so all databases will be local.

When I test the page on the Matrix test server it all works fine and I can edit fields and the update works as well. However, when I move the page onto an IIS 5.1 server on my machine (accessing the same mdb) the page renders OK and all data is populated. The edit buttons work and make the non-readonly fields editable but the Update doesn't work.

What could possibly cause this error and what is different between Cassini (is that Matrix's testing server?) and IIS 5.1? Has anyone else experienced similar problems?

Any help would be much appreciated.

I have uploaded the page to

HTTP://www.russgreen.net/software/newsgroupimages/db_project_list.aspx

You'll also need...

HTTP://www.russgreen.net/software/newsgroupimages/Edit.gif

HTTP://www.russgreen.net/software/newsgroupimages/web.config

the database is also there...

HTTP://www.russgreen.net/software/newsgroupimages/empty_projects.mdb

I do not have .NET hosting so you'll have to download and test these files.

The exception generated under IIS is below

System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at ASP.db_project_list_aspx.DataGrid_Update(Object s, DataGridCommandEventArgs e) in D:\Web Design Work\SALT_INTRANET\asp_net\db_project_list.aspx:line 68

Regards,
Russ

http://www.russgreen.net/software/

http://www.learnvisualstudio.net?referedby=38523

 

[merlyn2450]

sounds like a permissions issue. if you havent already, switch to advanced sharing by going to My Computer > Tools > Folder Options > View, then Deselect &quot;Use simple file sharing&quot;. Then, share the database or database folder with IIS (IUSR_<machine> and ASPNET). Give both accounts write access.

If that doesnt do it, ... well, i dont know