[SOLVED] ASP-MySQL Username Validation

'If there is no record with the entered username, close connection and go back to login with QueryString
    If rs.recordcount = 0 then
        rs.Close
        conn.Close
        set rs=nothing
        set conn=nothing
        Response.Redirect("login.asp?login=namefailed")
    end if

    set conn = server.CreateObject ("ADODB.Connection")        
    conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("mydatabase.mdb")
    set rs = server.CreateObject ("ADODB.Recordset")        
    'Open record with entered username
    rs.Open "SELECT * FROM userlist where username='"& Username &"'", conn, 1

    Dim connectionString, conn, rs
    connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mydatabase; OPTION=4; UID=root; PASSWORD=monie;"
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open(connectionString)
    Set rs = conn.Execute("SELECT * FROM userlist WHERE username='"& Username &"'")

'If there is no record with the entered username, close connection
'and go back to login with QueryString with the message username dont exist!
    If rs.recordcount = 0 then '<-- In MySQL, it's like they skips this line!
        rs.close
        conn.close
        set rs=nothing
        set conn=nothing
        Response.Redirect("login.asp?login=namefailed")
    end if

    'If there is no record with the entered username, close connection and go back to login with QueryString    
    If rs.BOF AND rs.EOF Then
        rs.Close
        conn.Close
        set rs=nothing
        set conn=nothing
        Response.Redirect("login.asp?login=usernamefailed")
    End If