Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
Jeg får denne fejl:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/stat.asp, line 30
Når jeg prøver:
strUA = Request.ServerVariables("HTTP_USER_AGENT")
response.write strUA&"<br>"
tmpArray = split(strUA,";")
browser = tmpArray(1)
os = tmpArray(2)
timeAndDate = now
ip = Request.ServerVariables("REMOTE_ADDR")
res = Request.QueryString("w") & "*" & Request.QueryString("h")
Response.Write _
"Time: "&timeAndDate&"<br>" & _
"Ip: "&ip&"<br>" & _
"Browser: "&browser&"<br>" & _
"Res: "&res&"<br>" & _
"Os: "&os&"<br>"
IQ1 = "INSERT INTO stat (time, ip, browser, res, os) " & _
"VALUES ("&now&",'"&ip&"','"&browser&"','"&res&"','"&os&"')"
objConnStat.Execute(IQ1)
Response.Write IQ1
I databasen er "time" Date/Time format
Hvad er der galt?
