By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,254 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Wierd issue with XP Home / XP Pro

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Jul 19 '05 #2

P: n/a
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"
Jul 19 '05 #3

P: n/a
"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.
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.