All of a sudden i am getting this error on my site. It was working fine before. The error only occurs when the sql query contain a date check.

sql="Select * From Log where logDate=#" & date & "#"
any other query is fine.

any ideas.
Here is my query

'check if an entry for today exist
sql="Select * From [Log] Where [IP]='" & ip_address & "' AND [Date]=#" & date & "# And UserId=" & userid

'this query runs fine
'sql="Select * From Log Where IP='" & ip_address & "'"
response.write sql

'Following is the line 103
set rsIP=conn.execute(sql)
Microsoft JET Database Engine (0x80040E14)
Internal OLE Automation error
/forum/include/inc_log.asp, line 103