Click to See Complete Forum and Search --> : error '80020009'


NoasIT
10-13-2010, 09:45 AM
I have been searching and it seems this error can mean a very large amount of different things. This error is coming up when attempting to log into the admin section of our site, which I did not code. Its been working fine since I started here about 5 months ago, all of a sudden I can't log in and I have no idea why! The exact error reads
error '80020009'

/admin/check.asp, line 10

And the strangely coded check.asp is

<!-- #INCLUDE FILE="include/conn.inc" -->

<%
strSQL="SELECT * FROM Users WHERE userName LIKE '"&request.form("username")&"' AND userPass LIKE '"&request.form("pass")&"'"
Set rst = CreateObject("ADODB.Recordset")
rst.Open strSQL, con, adOpenStatic, adLockReadOnly
%>

<%fname= request.form("username")
if request.form ("username")=rst("userName") and request.form("pass")=rst("userPass") then%>
<%Response.Cookies("sigin")="yes"%>
<%Response.Cookies("First_name")=""&fname&""%>
<%response.redirect "menu.asp"%>

<%else %>

<%response.write "login failed"
end if

%>

I know the code is horribly formatted, and the password is not secure at all but I am working on redoing the site to conform to proper standards and security until its done tho, we would like to be able to continue using the current site. Any thoughts would be appreciated.