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.
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 & "'"
'Following is the line 103
Microsoft JET Database Engine (0x80040E14)
Internal OLE Automation error
/forum/include/inc_log.asp, line 103