Wierd issue with XP Home / XP Pro

[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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003

[vool]

Hi, that is the case but I'm accessing the page on a remote webserver....not
an IIS issue...either ASP or XP Home...

http://wavestation.net/scotty
"Jim PKP" <ji*@nospam.com> wrote in message
news:MP************************@news1.eircom.net.. .

In article <uK**************@TK2MSFTNGP09.phx.gbl>, vo**@fsnet.com
says...

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.

Unlurking for a moment to suggest that, if I understand you right,
the problem is that XP Home does not support IIS.

--
| ji*@nospam.com | PandaKunda | aLsO nObiE | <no smileys> |

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003

[Jim PKP]

In article <eQ**************@TK2MSFTNGP09.phx.gbl>, vo**@fsnet.com
says...

Hi, that is the case but I'm accessing the page on a remote webserver....not
an IIS issue...either ASP or XP Home...

oh right - sorry.
no idea then!
--
| ji*@nospam.com |
"Insert Humorous Quote Here"

[Dave Anderson]

"vool" wrote:

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\Curr entVersion\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.