My page is producing the following error:
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Execute'
Validate.asp, line 15
The affected code (line 15) in Validate.asp is:
Set rs = conn.Execute(SQLString)
The SQLString that it runs is:
SQLString = "SELECT M.MANAGERID, M.BRANCHID, M.PERSONALID,
M.FIRSTNAME, M.SURNAME, M.TELEPHONENO, M.EMAIL, M.PASSWORD
FROM MANAGER M
WHERE ( M.PERSONALID = '" & LoginId & "' )
AND ( M.PASSWORD = '" & LoginPass & "' )"
Set rs = conn.Execute(SQLString)
The values for LoginId and LoginPass are retrieved this
way:
LoginId = request.form("LoginId")
LoginPass = request.form("LoginPass")
The Oracle 9i db connection string is:
Dim connStr, conn
connStr = "PROVIDER=MSDASQL; DRIVER={Microsoft ODBC for
ORACLE}; SERVER=servername; UID=idnumber; PWD=password;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Mode = 3
conn.Open connStr
What is causing the runtime error?