Hi,
Is VB script case sensitive ? If I enter "SAP" in the password field in logon screen it works. If I enter "sap" it won't. In database the password is stored as "SAP"
Page1.asp
-----------
<%@ Language=VBScript %>
<%
Dim userid
Dim password
Dim conn
Dim SQL
dim RS
userid = request("userid"
password = request("password"
Set conn = Server.CreateObject("ADODB.Connection"
conn.Open Application("ConnectionString"
session("Connection"
= conn
set RS = Server.Createobject("ADODB.Recordset"
SQL = "EXEC spValidateUser " + userid
RS.Open SQL, conn
if RS(0)= password then
Response.Redirect("AddMember.asp"
else
Response.write("Invalid password"
end if
%>
Is VB script case sensitive ? If I enter "SAP" in the password field in logon screen it works. If I enter "sap" it won't. In database the password is stored as "SAP"
Page1.asp
-----------
<%@ Language=VBScript %>
<%
Dim userid
Dim password
Dim conn
Dim SQL
dim RS
userid = request("userid"

password = request("password"

Set conn = Server.CreateObject("ADODB.Connection"

conn.Open Application("ConnectionString"

session("Connection"

set RS = Server.Createobject("ADODB.Recordset"

SQL = "EXEC spValidateUser " + userid
RS.Open SQL, conn
if RS(0)= password then
Response.Redirect("AddMember.asp"

else
Response.write("Invalid password"

end if
%>