Re: Operation must use an updateable query.

From: Pravin A. Sable (pravin_at_ccs.neu.edu)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 14:50:01 -0700

I gave administrative privileges for ASP.net user, the folder is in
Inetpub/wwwroot/web application1. Folder remains read only. but database
has permission to change. The problem comes between these lines

          DBInsert.Connection.Open()
         'Above statement makes the database read only.

        DBInsert.ExecuteNonQuery()
        'Above statemet gives an error
Alphonse Giambrone wrote:
> I just ran into this one a few days ago.
> You need to have write permission for the database file/folder.
>
>Please find the source code for this error in attachment.
>>
>> I am trying to execute following code
>>
>> Sub SubmitBtn_Click(ByVal Sender As Object, ByVal E As EventArgs)
>> Dim DBConn As OleDbConnection
>> Dim DBInsert As New OleDbCommand
>> DBConn = New OleDbConnection("PROVIDER=" _
>> & "Microsoft.Jet.OLEDB.4.0;" _
>> & "DATA SOURCE=" _
>> & Server.MapPath("Emps.mdb;"))
>> DBInsert.CommandText = "Insert Into Employees " _
>> & "(LastName, FirstName, PhoneNumber, EmailAddress, " _
>> & "Notes, DepartmentID) values (" _
>> & "'" & Replace(txtLastName.Text, "'", "''") & "', " _
>> & "'" & Replace(txtFirstName.Text, "'", "''") & "', " _
>> & "'" & Replace(txtPhoneNumber.Text, "'", "''") & "', " _
>> & "'" & Replace(txtEmailAddress.Text, "'", "''") _
>> & "', " _
>> & "'" & Replace(txtNotes.Text, "'", "''") & "', " _
>> & ddlDepartments.SelectedItem.Value & ")"
>> DBInsert.Connection = DBConn
>> DBInsert.Connection.Open()
>> DBInsert.ExecuteNonQuery()
>> Response.Redirect("./index.aspx")
>> End Sub
>>
>> while executing following
>> DBInsert.ExecuteNonQuery()
>>
>> query is
>> Insert Into Employees (LastName, FirstName, PhoneNumber, EmailAddress,
>> Notes, DepartmentID) values ('asdfas', 'asdf', 'asdfasfdasdf', 'asf',
>> 'asdfasdf', 3)
>>
>>
>> I get an error saying as follows, Whats happening... it's new to me..
>> more to that its an example striaght copy paste from one book.
>>
>>
>>
>> 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 58: DBInsert.Connection = DBConn
>> Line 59: DBInsert.Connection.Open()
>> Line 60: DBInsert.ExecuteNonQuery()
>> Line 61: Response.Redirect("./index.aspx")
>> Line 62: End Sub
>>
>>
>> Source File: c:\inetpub\wwwroot\WebApplication1\add1.aspx.vb Line: 60
>>
>> Stack Trace:
>>
>>
>> [OleDbException (0x80004005): Operation must use an updateable query.]
>> System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32

hr)

>>
>>

System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS

>> dbParams, Object& executeResult)
>> System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object&

executeResult)

>> System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior
>> behavior, Object& executeResult)
>> System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
>> behavior, String method)
>> System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
>> WebApplication1.add1.SubmitBtn_Click(Object Sender, EventArgs E) in
>> c:\inetpub\wwwroot\WebApplication1\add1.aspx.vb:60
>> System.Web.UI.WebControls.Button.OnClick(EventArgs e)
>>
>>

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String

>> eventArgument)
>> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
>> sourceControl, String eventArgument)
>> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
>> System.Web.UI.Page.ProcessRequestMain()
>>
>>
>>
>>