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

1
votes

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'

[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

1
asp-classic

1 Answers

2
votes

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