发新话题
打印

[网页] asp网页出现问题Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

asp网页出现问题Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

我在DW上编好网页,利用本地预览时,第一次都能预览,可是修改后就不能预览了,在浏览器出现了“Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] 不能使用 '(未知的)';文件已在使用中。”的错误,当游览器和DW都关闭,再在重新打开又可以预览了,请问高手应该如何解决呀?

TOP

补充

' *** Redirect if username exists
MM_flag="MM_insert"
If (CStr(Request(MM_flag)) <> "") Then
  MM_dupKeyRedirect="registNo.html"
  MM_rsKeyConnection=MM_conn_STRING
  MM_dupKeyUsernameValue = CStr(Request.Form("name"))
  MM_dupKeySQL="SELECT name FROM user WHERE name='" & MM_dupKeyUsernameValue & "'"
  MM_adodbRecordset="ADODB.Recordset"
  set MM_rsKey=Server.CreateObject(MM_adodbRecordset)
  MM_rsKey.ActiveConnection=MM_rsKeyConnection   注:提示此行错误
  MM_rsKey.Source=MM_dupKeySQL
  MM_rsKey.CursorType=0
  MM_rsKey.CursorLocation=2
  MM_rsKey.LockType=3
  MM_rsKey.Open
  If Not MM_rsKey.EOF Or Not MM_rsKey.BOF Then
    ' the username was found - can not add the requested username
    MM_qsChar = "?"
    If (InStr(1,MM_dupKeyRedirect,"?") >= 1) Then MM_qsChar = "&"
    MM_dupKeyRedirect = MM_dupKeyRedirect & MM_qsChar & "requsername=" & MM_dupKeyUsernameValue
    Response.Redirect(MM_dupKeyRedirect)
  End If
  MM_rsKey.Close
End If

TOP

发新话题