access 2000 con string?

  • Thread starter Thread starter CarpetMnuncher!
  • Start date Start date
C

CarpetMnuncher!

whats wrong with this ?

access 2000


Set Con = Server.CreateObject("ADODB.Connection")
Con.Open strCon
sql = "Select uName, pword from settings WHERE uname = 'kenney"&
session("site_username") & "' AND pword = 'homza"& 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
 
Back
Top