Perplexed - Microsoft OLE DB Provider for ODBC Drivers error '80040e14' error
Ok, so I have this legacy client who reached out to us regarding this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'S'.
/court_add.asp, line 40 ( aka set myRS=objConn.Execute(rsSQL) )
Problem is, I login to the site and it works for me. I've had him clear browser cache, and even reboot computer, but issue persists... on his end.
code section in question is:
Dim myRS
if Request("AddSw") = "Y" then
rsSQL = "SELECT Defendant_ID FROM Court_Rec WHERE " &_
"Eviction_Judgement_Date ='" & request("Eviction_Judgement_Date") & "' AND " &_
"Eviction_Case_Number ='" & request("Eviction_Case_Number") & "'"
set myRS=objConn.Execute(rsSQL)
if myRS.EOF then
myRS.Close
rsSql = "INSERT INTO Court_Rec (Defendant_Firstname, Defendant_Middle, Defendant_Lastname, Defendant_Suffix, " &_
"Apartment_Complex, Apartment_Number, Defendant_Street1, Defendant_City, Defendant_State, Defendant_Zipcode, " &_
"Plaintiff, Dist_Court, Eviction_Judgement_Date, Eviction_Case_Number, Concur_Valid, Concur_Liability, " &_
"RPOA_Number) VALUES (" &_
"'" & request("Defendant_Firstname") & "', " &_
"'" & request("Defendant_Middle") & "', " &_
"'" & request("Defendant_Lastname") & "', " &_
"'" & request("Defendant_Suffix") & "', " &_
"'" & request("Apartment_Complex") & "', " &_
"'" & request("Apartment_Number") & "', " &_
"'" & request("Defendant_Street1") & "', " &_
"'" & request("Defendant_City") & "', " &_
"'" & ucase(request("Defendant_State")) & "', " &_
"'" & request("Defendant_Zipcode") & "', " &_
"'" & request("Plaintiff") & "', " &_
"'" & ucase(request("Dist_Court")) & "', " &_
"'" & request("Eviction_Judgement_Date") & "', " &_
"'" & request("Eviction_Case_Number") & "', " &_
"1,1,'" & request("RPOA_Number") & "')"
set myRS=objConn.Execute(rsSQL)
'if accepted ...
if Session("RPOA_Level") = "10" then
goRedirect("admin_main.asp?msg=defendant record added- success")
else
'SUCCESS!
'Court record was successfully
'added to the database.
AlertRedirect "SUCCESS! \n Court record was successfully \n added to the database.", "tenant_main.asp"
end if
else
msg = "This Defendant Court record is already in the database!"
end if
else
'admin used session and request, tenant uses request only
if Request("RPOA_Number") <> "" and Session("RPOA_Level") = "10" then
nID = Request("RPOA_Number")
else
nID = Session("RPOA_Number")
end if
rsSql = "SELECT RPOA_Number, Association_Name FROM Member WHERE RPOA_Number = " & nID
set myRS=objConn.Execute(rsSQL)
end if
I don't see any issue, but what else might preclude it from working for them but not me?