 |
|
ASP.NET 2.0 รันบน IIS แล้ว error ผมลองรันบน Microsoft Visual Web Developer 2005 แล้วสามารถติดต่อกับ |
|
 |
|
|
 |
 |
|
Error ยังไงเหรอครับ มันฟ้อง Error ว่าอย่างไร
|
 |
 |
 |
 |
Date :
8 ก.ย. 2550 15:02:38 |
By :
madoadza |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
มัน error ที่บรรทัด Line 25 ครับ
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 23:
Line 24: Dim com As New OleDbCommand(sqlAdd, Conn)
Line 25: com.ExecuteNonQuery()
Line 26: Conn.Close()
Line 27:
Source File: C:\inetpub\wwwroot\Comments.aspx.vb Line: 25
Stack Trace:
[OleDbException (0x80004005): Operation must use an updateable query.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +108
Comments.cmdSave_Click(Object sender, EventArgs e) in C:\inetpub\wwwroot\Comments.aspx.vb:25
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1378; ASP.NET Version:2.0.50727.1378
|
 |
 |
 |
 |
Date :
9 ก.ย. 2550 13:50:49 |
By :
eaknaja |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
จะต้องกำหนด Permission โดยการเพิ่ม User ชื่อ Everyone และเลือก Full Control ครับ
Permission
mydatabase.mdb -> Right Click -> Properties -> Tab Security -> Add User Everyone (Full Control)
อ้างอิงจาก https://www.thaicreate.com/dotnet/forum/023681.html
|
 |
 |
 |
 |
Date :
2010-01-29 09:21:32 |
By :
ของ Mr Win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|