Server Error in '/' Application.

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 117:        nclique = nclique + 1
Line 118:        nsql = "UPDATE BANNER SET BANNER.CLIQUES = " & nclique & " WHERE (((BANNER.ID)=" & idbanner & "));"
Line 119:        acessobd.executenonquery(nsql)
Line 120:        response.redirect(url)
Line 121:    End Sub

Source File: C:\Inetpub\vhosts\itaquera.com.br\httpdocs\aspnet_client\functions.aspx.vb    Line: 119

Stack Trace:


[OleDbException (0x80004005): Operation must use an updateable query.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1007188
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +255
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +188
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161
   System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
   acessodados.AcessoBD.ExecuteNonQuery(String query) +75
   functionsjava.go_url_banner(String idbanner) in C:\Inetpub\vhosts\itaquera.com.br\httpdocs\aspnet_client\functions.aspx.vb:119
   functionsjava.Page_Load(Object sender, EventArgs e) in C:\Inetpub\vhosts\itaquera.com.br\httpdocs\aspnet_client\functions.aspx.vb:37
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.9174; ASP.NET Version:2.0.50727.9175