....You don't have a recordset object open. .EOF stands for End Of File and it is how you determine if a Recordset (or datastream) has read to the end of file. The response object does not, in fact, support EOF nor will it contain the data you are looking for in your if statement. The response object has to do with sending data to the browser.
you need to do this:
'If no match found, EOF is not true.
if NOT rec.EOF then
Response.Redirect("somepage.asp") 'Change to page redirect to after login
blankError="Invalid username." 'EOF is true, no match found.
In this instance you implicity convert the variable rec to a recordset.
I think you will find that that will work for you.
Lastly, as I said to neil please post all further questions in the Classic ASP Beginners forum since this forum is for .NET 1.1.
Read this if you want to know how to get a correct reply for your question:
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
Technical Editor for: Professional Search Engine Optimization with ASP.NET