BEGIN
SET @id = (SELECT ID FROM userdata WHERE Username = user AND Password = pass);
END

connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=" & db_server & ";PORT=" & db_port &  ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword & ";OPTION=" & db_option

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open connectstr

<!-- #include file="../assets/commonFiles/conn.asp" -->

varUsername = Request("Username")
varPassword = Request("Password")

cmd = Server.CreateObject("ADODB.Command")
cmd.CommandText = SP_Autentica
cmd.CommandType = 4
p = cmd.Parameters
p.Append(cmd.CreateParameter("@user","@pass"))
cmd("@user") = varUsername
cmd("@pass") = varPassword
cmd.ActiveConnection = Conn
cmd.Execute()