capturing data from the web using ASP?

[EddieY]

<%<br />
set conn=Server.CreateObject("ADODB.Connection")<br />
conn.Provider="Microsoft.Jet.OLEDB.4.0"<br />
<br />
dim a, b,c <br />
<br />
a = Now<br />
b= Request.ServerVariables("REMOTE_ADDR")<br />
c= Request.ServerVariables("REMOTE_HOST")<br />
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("sitestats.mdb")<br />
<br />
strSQL = "INSERT INTO tblStats (Recorded, RemoteAddress, RemoteHost) VALUES ('"& a &"','"& b &"','"& c &"')"<br />
<br />
conn.Execute(strSql) <- this line error saying that it is operation must use updatable query<br />
<br />
conn.close<br />
Set conn = Nothing<br />
%><br />
thanks for the answer after i added the permission for it. will choose u as a best ans. thanks<br />
<br />
another question, is there any betterway to implement for every pages for this other than add this additional code to each webpages?<br />

 

[Mehdi]

Do a Response.write strSQL and see what the querystring actually looks like.

 

[iqueen]

1 Press win+r, and input "odbcad32.exe", press Enter;
2 Switch to tab "Tracing";
3 Input log path;
4 Press Start ...
5 Execute your sql...
6 Press Stop.
-- Goodluck

 

[SalmanA]

Your MDB file is read only or your NTFS permissions only allow read access to MDB file, not write access.

Edit permissions on the MDB file. IUSR_MACHINENAME should have write permission on the MDB file.