Wierd issue with XP Home / XP Pro

V

vool

Hi all,

I've got a really wierd problem here.

When I access a web page that adds information to a database on a PC running
XP Pro it works as it should.

When I access the same page from a PC running XP Home I get a ' Internal
server error - page cannot be dispalyed' message.

I've tried it on 5 PC's running XP Pro & 5 running XP Home - same result.

ASP code is:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%
dim conn2,sql2
set conn2 = server.createobject ("ADODB.connection")
conn2.Provider="Microsoft.Jet.OLEDB.4.0"
conn2.Open(Server.Mappath("dat48372.mdb"))

sql2="INSERT INTO Tracker (qReferer, qLocAdd, qRemAdd, qUAgent)"
sql2=sql2 & " VALUES "
sql2=sql2 & "('" & request.servervariables("HTTP_REFERER") & "',"
sql2=sql2 & "'" & request.servervariables("LOCAL_ADDR") & "',"
sql2=sql2 & "'" & request.servervariables("REMOTE_ADDR") & "',"
sql2=sql2 & "'" & request.servervariables("HTTP_USER_AGENT") & "')"

conn2.Execute sql2
conn2.close
set conn2 = Nothing
%>

Can anyone help pls.

Thanks in advance

xool
 
D

Dave Anderson

vool said:
I Removed 'local_address' and 'http_user_agent' and it works
fine. For some reason PCs running xp home won't give out this
info and causes an error!

The user agent string has nothing whatsoever to do with the OS. It is sent
by the web browser. Certainly Mozilla running on XP Home would send a user
agent string.

That said, my guess is that there's some unhandled problem with
concatenation -- perhaps the machines in question have single-quote
characters in the UA strings, for example (you can add anything you like to
the string by adding a String Value to the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet
Settings\User Agent\Post Platform).

What does this page report for your XP Home machines?
http://www.ip-delivery.com/environment/


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top