Demo Setup Problem: Operation must use an updateable query???

Last post 09-30-2004, 10:41 AM by Adam. 1 replies.
Sort Posts: Previous Next
  •  09-29-2004, 4:44 PM 1947

    Demo Setup Problem: Operation must use an updateable query???

    Hi, I'm a relative newbie trying to figure out what's wrong here.  I'm using Dreamweaver MX2004, IE 6.0.  I created a site using the asp.netv1.1 folder in IIS (for both the local site and the testing server). 
     
    When I attempt to update an entry in the DataGrid example page through localhost, I get the following error:
     

    Operation must use an updateable query.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.

    Source Error:

    Line 141:		myCommand.Parameters.Add(new OleDbParameter("@EmpID", e.Item.Cells[1].Text ));
    Line 142:		conn.Open();
    Line 143:		myCommand.ExecuteNonQuery();
    Line 144:        MyDataGrid.EditItemIndex = -1;
    Line 145:		BindData();	
     
     
    Any thoughts???
     
    Thank you much!
     
     
    -George
  •  09-30-2004, 10:41 AM 1954 in reply to 1947

    Re: Demo Setup Problem: Operation must use an updateable query???

    George,
     
    This is the permission problem.
     
    In demo project the access database is used. In order to get updateable query work,  ASPNET account (account that is used to execute ASP.NET processes) has to have Write permissions on that folder.
     
    By default it does not, so you need to right-click the folder, go to security tab and add ASPNET account to the list, then grant write permissions to that account (by checking Write checkbox) and click OK.
     

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

View as RSS news feed in XML