将我的文件上传到Internet时出现错误？

Question

当我尝试注册用户时，任何人都可以帮助我收到错误，但本地一切正常，但在远程上传文件时出现错误。我的继承人代码

Dim conn As OleDbConnection 
    Dim strinsert As String 
    Dim cmdinsert As OleDbCommand 

    conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|sabersolutions.mdb") 
    strinsert = "INSERT INTO register(Name,Email,Passwords,Newsletter,ReportTemplates,ReturningMember,Sponsor)SELECT TOP 1 @Name,@Email,@Passwords,@Newsletter,@ReportTemplates,@ReturningMember,@Sponsor FROM register WHERE NOT EXISTS(SELECT 1 FROM register WHERE [email protected] AND [email protected] AND [email protected] AND [email protected] AND [email protected] AND [email protected] AND [email protected])" 

    cmdinsert = New OleDbCommand(strinsert, conn) 
    cmdinsert.Parameters.Add("@Name", OleDbType.VarWChar, 255).Value = txtName.Text 
    cmdinsert.Parameters.Add("@Email", OleDbType.VarWChar, 255).Value = txtEmail.Text 
    cmdinsert.Parameters.Add("@Passwords", OleDbType.VarWChar, 255).Value = txtPass.Text 
    cmdinsert.Parameters.Add("@Sponsor", OleDbType.Boolean, 1).Value = ckSponsor.Checked 
    cmdinsert.Parameters.Add("@Newsletter", OleDbType.Boolean, 1).Value = ckNews.Checked 
    cmdinsert.Parameters.Add("@ReportTemplates", OleDbType.Boolean, 1).Value = ckReportTemp.Checked 
    cmdinsert.Parameters.Add("@ReturningMember", OleDbType.Boolean, 1).Value = ckRSponsor.Checked 
    cmdinsert.Parameters.Add("@Sponsor", OleDbType.Boolean, 1).Value = ckSponsor.Checked 

    cmdinsert.Connection.Open() 

    cmdinsert.ExecuteNonQuery() 

    cmdinsert.Connection.Close() 

    LblSuccess.Text = "You have successfully Register, Please Login to view our Online Booking Sytem." 

错误我得到

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 27:   cmdinsert.Connection.Open() 
Line 28: 
Line 29:   cmdinsert.ExecuteNonQuery() 
Line 30: 
Line 31:   cmdinsert.Connection.Close() 

Source File: C:\inetpub\vhosts\sabersolutions.co.za\httpdocs\RegisterandLoginForm.aspx.vb Line: 29 

堆栈跟踪：

[OleDbException (0x80004005): Operation must use an updateable query.] 
    System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1081356 
    System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +247 
    System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194 
    System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58 
    System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +167 
    System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113 
    RegisterandLoginForm.Button2_Click(Object sender, EventArgs e) in C:\inetpub\vhosts\sabersolutions.co.za\httpdocs\RegisterandLoginForm.aspx.vb:29 
    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118 
    System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112 
    System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 
    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 
    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563 

版本信息：Microsoft .NET Framework版本：4.0.30319; ASP.NET版本：4.0.30319.272

Answer 1

我远不是Access的新手，但是你的查询有错误;

.... 
SELECT TOP 1 @Name,@Email,@Passwords,@Newsletter, 
      @ReportTemplates,@ReturningMember,@Sponsor 
FROM register 
... 

应该是;

.... 
SELECT TOP 1 Name,Email,Passwords,Newsletter, 
      ReportTemplates,ReturningMember,Sponsor 
FROM register 
... 

你的“更新查询”问题，但最有可能是你想获取使用SQL Server UPDATE查询虽然，访问UPDATE语法是远离标准和它可能需要重写子查询作为加入。有更多Access-Foo的人可能会帮助你。

或者，您可以尝试访问查询向导，它可以帮助您用正确的Access语法重写查询。