XP Home won't open a remote page that XP Pro will

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 remote 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 an ' Internal
    server error - page cannot be displayed' 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. page is http://wavestation.biz/scotty

    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

    Ray at Guest

    Or announce that you got this figured out in your other identical thread.

    Ray at work

    "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
    news:...
    > First find out what the error is.
    > http://www.aspfaq.com/2109
    >
    > Ray at work
    >
    > "vool" <> wrote in message
    > news:...
    > > Hi all,
    > >
    > > I've got a really wierd problem here.
    > >
    > >
    > > When I access the same page from a PC running XP Home I get an '

    Internal
    > > server error - page cannot be displayed' message.

    >
    >
    Ray at, Aug 1, 2003
    #2
    1. Advertising

  3. vool

    Mpaintnz Guest

    "vool" <> wrote in message
    news:...
    > Hi all,
    >
    > I've got a really wierd problem here.
    >
    > When I access a remote 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 an ' Internal
    > server error - page cannot be displayed' 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. page is http://wavestation.biz/scotty


    I didn't get any error messages with Opera 7, but then again that is an
    *.HTM file
    <META NAME="author" CONTENT="J M Neary">
    <LINK REV="made" HREF="">
    <META NAME="copyright" CONTENT="2003 Terra-Byte">


    Have you tried debugging your ASP?
    e.g replacing CONN2.EXECUTE SQL2 with RESPONSE.WRITE SQL2 and comparing the
    difference?

    Since while I don't know, I do suspect that the two client dependent values
    HTTP_USER_AGENT and HTTP_REFERER are the most likely suspects.

    HINT: To prevent hacking, check any user editable strings like
    HTTP_REFERER's for badness before giving them to SQL, your current
    implementation doesn't stop someone squirting a referer string like
    server.urlencode("Host',"","","");DELETE tracker.*;")
    which if it didn't include deliberate syntax errors could **** your table
    contents.

    And since you have published the script syntax and URL to the world, you
    might want to patch that hole fast, da?
    And is dat48372.mdb supposed to be world readable?
    Mpaintnz, Aug 6, 2003
    #3
    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:
    320
    nancyflorida
    Nov 12, 2007
  2. nancyflorida
    Replies:
    0
    Views:
    306
    nancyflorida
    Nov 12, 2007
  3. * Its my Pleasure *
    Replies:
    0
    Views:
    364
    * Its my Pleasure *
    Feb 20, 2008
  4. Wayne Erfling
    Replies:
    0
    Views:
    317
    Wayne Erfling
    Nov 18, 2006
  5. vool

    Wierd issue with XP Home / XP Pro

    vool, Aug 1, 2003, in forum: ASP General
    Replies:
    3
    Views:
    111
    Dave Anderson
    Aug 1, 2003
Loading...

Share This Page