Set myConnection=Server.CreateObject("ADODB.Connection")
conStr="PROVIDER=SQLOLEDB;DSN=;uid=;pwd="
myConnection.open conStr
Set myRecordSet=Server.CreateObject("ADODB.RecordSet")
mySql="select * from Students where StudentNumber="
mySql=mySql&number&"and StudentPassword="&password