MicrosoftOLEDBProviderforODBCDrivers错误'80040e14'

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access Driver] 无效的括号名称 '[鐢ㄦ埛鍚峕, [瀵嗙爜]'。

/dlym.asp，行 42

MM_loginSQL = "SELECT [用户名], [密码]"

  If MM_fldUserAuthorization <> "" Then MM_loginSQL = MM_loginSQL & "," & MM_fldUserAuthorization

  MM_loginSQL = MM_loginSQL & " FROM yonghuxinxi WHERE [用户名] = ? AND [密码] = ?"

  Set MM_rsUser_cmd = Server.CreateObject ("ADODB.Command")

  MM_rsUser_cmd.ActiveConnection = MM_music_STRING

  MM_rsUser_cmd.CommandText = MM_loginSQL

  MM_rsUser_cmd.Parameters.Append MM_rsUser_cmd.CreateParameter("param1", 5, 1, -1, MM_valUsername) ' adDouble

  MM_rsUser_cmd.Parameters.Append MM_rsUser_cmd.CreateParameter("param2", 5, 1, -1, Request.Form("textfield2")) ' adDouble

  MM_rsUser_cmd.Prepared = true

  Set MM_rsUser = MM_rsUser_cmd.Execute

  Set MM_rsUser = MM_rsUser_cmd.Execute

这一行代码有问题