Error 800a0e7d
I need some help if poss. I am new to ASP and have developed a site which queries a Db, but after uploading to the remote server |I get an error in the log on page
Error ..ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/login.asp, line 20
My page code is:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="./Connections/.........
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)
MM_valUsername=CStr(Request.Form("username"))
If MM_valUsername <> "" Then
MM_fldUserAuthorization="intAccesslevel"
MM_redirectLoginSuccess="members_front.asp"
MM_redirectLoginFailed="failed.asp"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.Source = "SELECT txtUsername, txtPassword"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM tbleUsers WHERE txtUsername='" & Replace(MM_valUsername,"'","''") &"' AND txtPassword='" & Replace(Request.Form("password"),"'","''") & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
HEEEEEELPPPPPPPPPPPPP
Mattloo
|
