codice:
Select count(*) as totRighe from tabella where ....

if rs("totRighe") > 0 then
   response.write("Autenticazione OK!")
else
   response.write("Autenticazione KO!")
end if