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

I'm trying to figure out this error message and I'm not sure what exactly is the issue.

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

开发者_StackOverflow社区

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

tmpsql = "select EVE_GID from Events where EVE_DATED = '" & request("EVE_DATED") & "' and 
EVE_STARTTIME = '" & request("EVE_DATED") & " " & request("EVE_STARTTIME") & "'"

rs.Open tmpsql,MM_editConnection

I think it has to do with my quotes but I'm not sure. Can anyone give me a clue on why I keep getting this error message? The data is hosted on a SQL server.

O yes EVE_GID = int EVE_DATED = datetime EVE_STARTTIME = datetime

---

Spit out your SQL statement before you execute it an see what you're getting:

tmpsql = "select EVE_GID from Events where EVE_DATED = '" & request("EVE_DATED") & "' and 
EVE_STARTTIME = '" & request("EVE_DATED") & " " & request("EVE_STARTTIME") & "'"

response.write(tmpsql)

'rs.Open tmpsql,MM_editConnection <-- comment out this