ASP Classic - Data type mismatch error

Question

I'm trying to make an ID (primary key and autoincrement) from the MS Access database to be used as a login pass. But I'm receiving this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

And here is my code:

con.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath("db.mdb") &""
sql="SELECT * FROM tblLogin WHERE ID='" & request.form("id") & "';"

rs.CursorType=2

rs.Open sql,con

if rs.bof then
   response.redirect "loginpage.asp?msg=ID does not exist."
else
   response.redirect "adminpage.asp"
end if

Please correct me if I'm missing something or any solutions that you recommend.

Thanks in advance.

It look alike you are sending ID as a string. Should it be an int? If so drop the apostrophe's around it. — StephenCollins
Oh thanks. I already removed the quotation marks and I received this error: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed. Any solutions? — user3130849
this one? sql="SELECT * FROM tblLogin WHERE ID='" & request.form(id) & "';" — user3130849
Try it like this and see what happens... sql="SELECT * FROM tblLogin WHERE ID=" & request.form("id") — StephenCollins

meda meda · Accepted Answer · 2014-03-03T22:01:06

Change:

sql="SELECT * FROM tblLogin WHERE ID='" & request.form("id") & "';"

to

sql="SELECT * FROM tblLogin WHERE ID=" & request.form("id")

Then check like this:

If rs.EOF then
   response.redirect "loginpage.asp?msg=ID does not exist."
else
   response.redirect "adminpage.asp"
end if

ASP Classic - Data type mismatch error

2 Answers