connection string ?

[CarpetMnuncher!]

What's wrong with this?

Set Con = Server.CreateObject("ADODB.Connection")
Con.Open strCon
sql = "Select uName, pword from settings WHERE uname = '"&
session("site_username") & "' AND pword = '"& session("site_password") & "'"
set rec = Con.execute(sql)
if rec.eof then
response.redirect "login.asp"
end if


rec.close
set rec = nothing
Con.close
set Con = nothing

 

[Brendan Reynolds]

Can't see anything obviously wrong. What happens when the code runs? Are you
getting an error message?