Username and PIN

To access your database you need a connection object and a connectionstring so the connection object can finde the databasen.

'Example for access database.:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\inetpub\wwwroot\mydb.mdb"

For other types of connection take at look here:
http://www.connectionstrings.com


To verify ID and PW you can create a SQL statement:

ID = Request.Form("ID")
PW = Request.Form("PW")
SQL = "SELECT * FROM tablename WHERE ID_FIELD = '" & id & "' AND PW_FIELD = '" & pw & "'"
Set rs = Conn.Execute(SQL)
if not (rs.EOF or rs.BOF) then
  'The user is in the database

else
  'Unknow user not match found for ID and PW

end if
Conn.Close
Set conn=nothing

remember to replace:
ID = Replace(Request.Form("ID"),"'","''")
PW = Replace(Request.Form("PW"),"'","''")

otherwise your login will be unsecure

hallo viking_sk sker her snart noget?