Hello all!:)

I am getting the following error message and as I am certainly not a professional at this i need a Guru's help solving. Thanks for any posts and your time!

IE error message reads:

Microsoft JET Database Engine error '80004005'

Unspecified error

/user_login.asp, line 14



Here is line 14:

MM_rsUser.ActiveConnection = MM_connUsers_STRING




Now here is the relevent code for that page:

<%@LANGUAGE="VBSCRIPT"%>

<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString
MM_valUsername=CStr(Request.Form("username"))
If MM_valUsername <> "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="begin_search.asp"
MM_redirectLoginFailed="login_fail.asp"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_connUsers_STRING
MM_rsUser.Source = "SELECT Username, Password"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM tblUsers WHERE Username='" & MM_valUsername &"' AND Password='" & CStr(Request.Form("password")) & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
    ' username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername
    strIpAddress = Request.ServerVariables("REMOTE_ADDR")
    strUserAgent = Request.ServerVariables("HTTP_USER_AGENT")
    SQL = "UPDATE tblUsers SET IpAddress = '" & strIpAddress & "', UserAgent = '" & strUserAgent & "' WHERE Username = '" & MM_valUsername & "'"
    MM_connUsers_STRING.Execute(SQL)
    If (MM_fldUserAuthorization <> "") Then
     Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization ).Value)
    Else
     Session("MM_UserAuthorization") = ""
    End If
    if CStr(Request.QueryString("accessdenied")) <> "" And false Then
     MM_redirectLoginSuccess = Request.QueryString("accessdenied")
    End If
    MM_rsUser.Close
    Response.Redirect(MM_redirectLoginSuccess)
End If
MM_rsUser.Close
Response.Redirect(MM_redirectLoginFailed)
End If
%>




The line is correct path. I have a total of 4 db's on the site and all of them are having the same problem. Sound like a file read/write problem? Its my only my guess.

Hi there,

How does your connection string look like? To what kind of database are you connecting? How is security setup on your server and database?

Maybe this will help:
http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263

If it doesn't, can you post a bit more background info like database, connection string etc....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Mezzanine by Massive Attack (Track 9 from the album: Mezzanine) What's This?