Hello,

I am trying to write a holding page that will track who has open the site. The table is access and is called "tracking". I have a system DSN setup that I have used to query another table so I believe that is working Fine.

The code at present looks like this:

<%
Dim StrConn, objConn, objRS, strSQL
strConn="DSN=FranticStar"
set objConn = server.CreateObject("ADODB.Connection")
objConn.Open strConn
set objRS = server.CreateObject("ADODB.recordset")
objRS.Open "tracking",objConn
objRS.AddNew
objRS.Fields("Time") = "#" & now & "#"
objRS.Fields("ip") = "'" & request.servervariables("remote_addr") & "'"
objRS.Fields("user") = "'" & Request.ServerVariables("LOGON_USER") & "'"
objRS.Update
objRS.Close
set objRS=nothing
objConn.Close
set objConn=nothing
%>
<P align=center>&nbsp;</P>
<P align=center>&nbsp;</P>
<P align=center><IMG src="images/FranticStar.jpg" width="353" height="50"
></P>
<P align=center>Cooming Soon</P>

</BODY>
</HTML>

However I get :The page cannot be displayed message! :(

Can anyone help?

www.franticstar.co.uk

Hi there,

You may need to enable more detailed error messages in either your browser, or at the server (or both). For the browser (IE), open the Options panel, switch to the Advanced tab and disable Show friendly HTTP error messages. For IIS, open your site, click the Configuration button on either the Directory or Home Directory tab, and then switch to the Debugging tab. Make sure that Send detailed ASP error messages to client is checked.

Once you have done that, rerun the page and a detailed error message will appear. Post that message to this list, so we can take a look at it.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

OK now I get:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/Test/test.asp, line 14


www.franticstar.co.uk

Right. That's at least easier to work with.

I think this error is caused by the fact that your current recordset does not support AddNew. Take a look at this site for possible solutions. Especially step 3 is worth looking at.

To fix this, pass in the right parameters to the Open method. To see what you need to pass, take a look here: http://msdn.microsoft.com/library/de...mdamth03_2.asp

To pass in the right constants for LockType and CursorType, make sure your calling code can see them correctly. For hints on how to do this, look here: http://www.adopenstatic.com/faq/800a0bb9step2.asp

If possible, go with recommendation number 1.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.