Wierd issue with XP Home / XP Pro

Discussion in 'ASP General' started by vool, Aug 1, 2003.

  1. vool

    vool Guest

    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, Aug 1, 2003
    #1
    1. Advertising

  2. vool

    vool Guest

    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" <> wrote in message
    news:...
    > In article <uK6#>,
    > 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.
    >
    > --
    > | | 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
     
    vool, Aug 1, 2003
    #2
    1. Advertising

  3. vool

    Jim PKP Guest

    In article <>,
    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!


    --
    | |
    "Insert Humorous Quote Here"
     
    Jim PKP, Aug 1, 2003
    #3
  4. "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\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.
     
    Dave Anderson, Aug 1, 2003
    #4
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. nancyflorida
    Replies:
    0
    Views:
    358
    nancyflorida
    Nov 12, 2007
  2. nancyflorida
    Replies:
    0
    Views:
    336
    nancyflorida
    Nov 12, 2007
  3. * Its my Pleasure *
    Replies:
    0
    Views:
    396
    * Its my Pleasure *
    Feb 20, 2008
  4. Wayne Erfling
    Replies:
    0
    Views:
    354
    Wayne Erfling
    Nov 18, 2006
  5. vool
    Replies:
    2
    Views:
    138
    Mpaintnz
    Aug 6, 2003
Loading...

Share This Page