Problem with Insert in to IP to Microsoft Acess by ASP

[minhadd]

Hello

Would Anyone help me ??

I want insert into Microsoft Acess visitor's IP by ASP. But It is not
working

----------------------------------------------------------------------------------------------------------

NOT WORK

<%
........

time = now()
ipp = Request.ServerVariables("remote_addr")

strSQL = "INSERT INTO visitor (time,ipp) VALUES ('" & time & "','" &
ipp & "')"
Set rs = myConnection.Execute(strSQL)
........

%>

-----------------------------------------------------------------------------------------------------------

I tested part of the ASP script then It work very well. Below:

WORK VERY WELL

<%
.......

time = now()

strSQL = "INSERT INTO visitor (time) VALUES ('" & time & "')"
Set rs = myConnection.Execute(strSQL)

......

%>

I created Access database. There are 2 field : time and ipp. Data type
of time is date. Data tye of IPP is text.

I think: Maybe in Access database: the field IPP was problem with data
type.

Thank you for your help...
http://www.anluc.com