ASP access via OpenLink, Progress 9.1C

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default ASP access via OpenLink, Progress 9.1C

    Summary:

    -Windows Professional machines accessing ASP app via IE 6
    -Web Server (IIS 5.0) on DMZ
    -File Server (Windows 2000 Server) is not on DMZ
    -ASP application needs to be able to access JPEGS on file
    server, but currently cannot.
    -DB Server (Windows 2000 Server), separate server from
    file server, not on DMZ
    -ASP app queries Progress 9.1C DB Server via OpenLink
    driver perfectly
    -Everything is on same LAN, just the DMZ and others on
    different subnets
    -The security on IIS Server is set to Windows integrated,
    as well as anonymous.
    -All domain users have read access to the folder that
    contains the JPEGS on the file server

    Details:

    I have a web server setup on a DMZ with an ASP
    application that is trying to access JPEGS on a file
    server that is not on the DMZ. I have a mapped drive
    setup on the web server pointing to the location of the
    JPEG images. The other functions of the ASP app work fine
    (query Progress DBMS). The database management system is
    Progress 9.1C, and I am using the OpenLink driver. I can
    access the main ASP application great on the server, and
    it is able to query data directly from the Progress
    database. However, when the pop-up appears within the ASP
    application that shows the JPEGS that are available,
    there are no hyperlinks to those JPEG files (this should
    be the case if things are setup properly). Everyone
    (including the anonymous account for this web server) has
    access to the folder with the JPEGS on the file server.
    What might I be missing here? Both anonymous and Windows
    Integrate Authentication are checked in the Internet
    Services Manager for the properties of this new site.

    Any ideas?

    MJ Guest

  2. Similar Questions and Discussions

    1. Openlink returns no records
      I've seen some previous posts with no resolution so I thought I would try again. I'm using the Openlink 4.2 ODBC drivers to connect to an Informix...
    2. #13809 [Bgs]: Openlink 3.2 and 4.0 odbc_do and single quotes
      Grant Is this still an issue? Emmon Simbo Technical Services Manager OpenLink Software php-bugs@lists.php.net ("Grant dot Walters at walters...
    3. #24606 [Bgs]: Compile Error- Unable to install OpenLink IODBC Support
      ID: 24606 User updated by: wolf at nbm dot com Reported By: wolf at nbm dot com Status: Bogus Bug Type: ...
    4. #24606 [NEW]: Compile Error- Unable to install OpenLink IODBC Support
      From: wolf at nbm dot com Operating system: Red Hat Linux 8.0 PHP version: 4.3.2 PHP Bug Type: ODBC related Bug description:...
    5. #13809 [Opn->Bgs]: Openlink 3.2 and 4.0 odbc_do and single quotes
      ID: 13809 Updated by: sniper@php.net Reported By: Grant dot Walters at walters dot co dot nz -Status: Open...
  3. #2

    Default Re: ASP access via OpenLink, Progress 9.1C

    does it show up as a broken image, or no image at all.


    "MJ" <anonymous@discussions.microsoft.com> wrote in message
    news:069301c3a4d6$eb97da20$a301280a@phx.gbl...
    > Summary:
    >
    > -Windows Professional machines accessing ASP app via IE 6
    > -Web Server (IIS 5.0) on DMZ
    > -File Server (Windows 2000 Server) is not on DMZ
    > -ASP application needs to be able to access JPEGS on file
    > server, but currently cannot.
    > -DB Server (Windows 2000 Server), separate server from
    > file server, not on DMZ
    > -ASP app queries Progress 9.1C DB Server via OpenLink
    > driver perfectly
    > -Everything is on same LAN, just the DMZ and others on
    > different subnets
    > -The security on IIS Server is set to Windows integrated,
    > as well as anonymous.
    > -All domain users have read access to the folder that
    > contains the JPEGS on the file server
    >
    > Details:
    >
    > I have a web server setup on a DMZ with an ASP
    > application that is trying to access JPEGS on a file
    > server that is not on the DMZ. I have a mapped drive
    > setup on the web server pointing to the location of the
    > JPEG images. The other functions of the ASP app work fine
    > (query Progress DBMS). The database management system is
    > Progress 9.1C, and I am using the OpenLink driver. I can
    > access the main ASP application great on the server, and
    > it is able to query data directly from the Progress
    > database. However, when the pop-up appears within the ASP
    > application that shows the JPEGS that are available,
    > there are no hyperlinks to those JPEG files (this should
    > be the case if things are setup properly). Everyone
    > (including the anonymous account for this web server) has
    > access to the folder with the JPEGS on the file server.
    > What might I be missing here? Both anonymous and Windows
    > Integrate Authentication are checked in the Internet
    > Services Manager for the properties of this new site.
    >
    > Any ideas?
    >

    Jeff Clark Guest

  4. #3

    Default Re: ASP access via OpenLink, Progress 9.1C

    A popup window is configured to come up with the listed
    designs (JPEGS). If things work correctly, they should
    be hypelinked to click on; after the click, the JPEGS
    would come up. They currently do not have available
    hyperlinks.
    >-----Original Message-----
    >does it show up as a broken image, or no image at all.
    >
    >
    >"MJ" <anonymous@discussions.microsoft.com> wrote in
    message
    >news:069301c3a4d6$eb97da20$a301280a@phx.gbl...
    >> Summary:
    >>
    >> -Windows Professional machines accessing ASP app via
    IE 6
    >> -Web Server (IIS 5.0) on DMZ
    >> -File Server (Windows 2000 Server) is not on DMZ
    >> -ASP application needs to be able to access JPEGS on
    file
    >> server, but currently cannot.
    >> -DB Server (Windows 2000 Server), separate server from
    >> file server, not on DMZ
    >> -ASP app queries Progress 9.1C DB Server via OpenLink
    >> driver perfectly
    >> -Everything is on same LAN, just the DMZ and others on
    >> different subnets
    >> -The security on IIS Server is set to Windows
    integrated,
    >> as well as anonymous.
    >> -All domain users have read access to the folder that
    >> contains the JPEGS on the file server
    >>
    >> Details:
    >>
    >> I have a web server setup on a DMZ with an ASP
    >> application that is trying to access JPEGS on a file
    >> server that is not on the DMZ. I have a mapped drive
    >> setup on the web server pointing to the location of the
    >> JPEG images. The other functions of the ASP app work
    fine
    >> (query Progress DBMS). The database management system
    is
    >> Progress 9.1C, and I am using the OpenLink driver. I
    can
    >> access the main ASP application great on the server,
    and
    >> it is able to query data directly from the Progress
    >> database. However, when the pop-up appears within the
    ASP
    >> application that shows the JPEGS that are available,
    >> there are no hyperlinks to those JPEG files (this
    should
    >> be the case if things are setup properly). Everyone
    >> (including the anonymous account for this web server)
    has
    >> access to the folder with the JPEGS on the file server.
    >> What might I be missing here? Both anonymous and
    Windows
    >> Integrate Authentication are checked in the Internet
    >> Services Manager for the properties of this new site.
    >>
    >> Any ideas?
    >>
    >
    >
    >.
    >
    Guest

  5. #4

    Default Re: ASP access via OpenLink, Progress 9.1C

    post the source of the popup window please

    <anonymous@discussions.microsoft.com> wrote in message
    news:0a4301c3a53c$76379200$a601280a@phx.gbl...
    > A popup window is configured to come up with the listed
    > designs (JPEGS). If things work correctly, they should
    > be hypelinked to click on; after the click, the JPEGS
    > would come up. They currently do not have available
    > hyperlinks.
    >
    > >-----Original Message-----
    > >does it show up as a broken image, or no image at all.
    > >
    > >
    > >"MJ" <anonymous@discussions.microsoft.com> wrote in
    > message
    > >news:069301c3a4d6$eb97da20$a301280a@phx.gbl...
    > >> Summary:
    > >>
    > >> -Windows Professional machines accessing ASP app via
    > IE 6
    > >> -Web Server (IIS 5.0) on DMZ
    > >> -File Server (Windows 2000 Server) is not on DMZ
    > >> -ASP application needs to be able to access JPEGS on
    > file
    > >> server, but currently cannot.
    > >> -DB Server (Windows 2000 Server), separate server from
    > >> file server, not on DMZ
    > >> -ASP app queries Progress 9.1C DB Server via OpenLink
    > >> driver perfectly
    > >> -Everything is on same LAN, just the DMZ and others on
    > >> different subnets
    > >> -The security on IIS Server is set to Windows
    > integrated,
    > >> as well as anonymous.
    > >> -All domain users have read access to the folder that
    > >> contains the JPEGS on the file server
    > >>
    > >> Details:
    > >>
    > >> I have a web server setup on a DMZ with an ASP
    > >> application that is trying to access JPEGS on a file
    > >> server that is not on the DMZ. I have a mapped drive
    > >> setup on the web server pointing to the location of the
    > >> JPEG images. The other functions of the ASP app work
    > fine
    > >> (query Progress DBMS). The database management system
    > is
    > >> Progress 9.1C, and I am using the OpenLink driver. I
    > can
    > >> access the main ASP application great on the server,
    > and
    > >> it is able to query data directly from the Progress
    > >> database. However, when the pop-up appears within the
    > ASP
    > >> application that shows the JPEGS that are available,
    > >> there are no hyperlinks to those JPEG files (this
    > should
    > >> be the case if things are setup properly). Everyone
    > >> (including the anonymous account for this web server)
    > has
    > >> access to the folder with the JPEGS on the file server.
    > >> What might I be missing here? Both anonymous and
    > Windows
    > >> Integrate Authentication are checked in the Internet
    > >> Services Manager for the properties of this new site.
    > >>
    > >> Any ideas?
    > >>
    > >
    > >
    > >.
    > >

    Jeff Clark Guest

  6. #5

    Default Re: ASP access via OpenLink, Progress 9.1C

    The problems lies at the end of the function where the
    call to FileExists always returns false:


    function GetImagePath(sDesignCode)
    ' Constructs the path to the images, given the design
    code.

    dim sPath ' current mapped path.
    change if the system's mapping changes.
    dim sFullPath ' the path including the file
    name to retrieve.
    dim lCodeNum ' numeric code of the design
    dim sFileCheck ' File check status
    dim sChar
    dim sCharEnd ' Last character (if non-numeric)
    dim i
    dim lLowerBound ' lowerbound numeric value for
    the folder name
    dim lUpperBound ' upperbound numeric value for
    the folder name
    dim filesys
    dim filedrive
    dim filefolder
    dim filecollection
    dim file
    dim filename

    'sPath = "M:\JPEGS\"
    sPath = "O:\"
    'sPath="\\server1\mac1\jpegs\"

    ' Parse till the first number.
    i = 0
    sChar = ""
    while not isnumeric(sChar) and i < len
    (sDesignCode)
    i = i + 1
    sChar = mid(sDesignCode, i , 1)
    wend

    if not isnumeric(right(sDesignCode, 1)) then
    sCharEnd = Right(sDesignCode, 1)
    else
    sCharEnd = ""
    end if

    if i <= len(sDesignCode) and ucase(left
    (sDesignCode, 1)) = "D" then
    ' Extract the numeric portion of the
    design code.

    if sCharEnd <> "" then
    ' Assumes there can only be one
    non-numeric char at the end.
    lCodeNum = CLng(mid(sDesignCode,
    i, len(sDesignCode)-i))
    else
    lCodeNum = CLng(mid(sDesignCode,
    i, len(sDesignCode)-i + 1))
    end if

    if lCodeNum <= 9000 then
    lLowerBound = 0
    lUpperBound = 9000
    elseif lCodeNum <= 10000 then
    lLowerBound = 9000
    lUpperBound = 10000
    else
    lLowerBound = ((lCodeNum \ 10000)
    * 10000) + 1
    lUpperBound = ((lCodeNum \ 10000)
    + 1) * 10000
    end if

    sPath = sPath & lLowerBound & "-" &
    lUpperBound
    sFullPath = sPath & "\" & lCodeNum &
    sCharEnd & ".jpg"

    ' Check to see if the file actually
    exists. If not, return path="#"
    set filesys = Server.CreateObject
    ("Scripting.FileSystemObject")

    'response.write sFullpath & "&nbsp;[" &
    filesys.FileExists(sFullPath) & "]<br>"
    if not filesys.FileExists(sFullPath) then
    sFullPath = "#"
    end if

    else
    sFullPath="#"
    end if

    GetImagePath = sFullPath
    end function
    >-----Original Message-----
    >post the source of the popup window please
    >
    ><anonymous@discussions.microsoft.com> wrote in message
    >news:0a4301c3a53c$76379200$a601280a@phx.gbl...
    >> A popup window is configured to come up with the listed
    >> designs (JPEGS). If things work correctly, they should
    >> be hypelinked to click on; after the click, the JPEGS
    >> would come up. They currently do not have available
    >> hyperlinks.
    >>
    >> >-----Original Message-----
    >> >does it show up as a broken image, or no image at all.
    >> >
    >> >
    >> >"MJ" <anonymous@discussions.microsoft.com> wrote in
    >> message
    >> >news:069301c3a4d6$eb97da20$a301280a@phx.gbl...
    >> >> Summary:
    >> >>
    >> >> -Windows Professional machines accessing ASP app via
    >> IE 6
    >> >> -Web Server (IIS 5.0) on DMZ
    >> >> -File Server (Windows 2000 Server) is not on DMZ
    >> >> -ASP application needs to be able to access JPEGS on
    >> file
    >> >> server, but currently cannot.
    >> >> -DB Server (Windows 2000 Server), separate server
    from
    >> >> file server, not on DMZ
    >> >> -ASP app queries Progress 9.1C DB Server via
    OpenLink
    >> >> driver perfectly
    >> >> -Everything is on same LAN, just the DMZ and others
    on
    >> >> different subnets
    >> >> -The security on IIS Server is set to Windows
    >> integrated,
    >> >> as well as anonymous.
    >> >> -All domain users have read access to the folder
    that
    >> >> contains the JPEGS on the file server
    >> >>
    >> >> Details:
    >> >>
    >> >> I have a web server setup on a DMZ with an ASP
    >> >> application that is trying to access JPEGS on a file
    >> >> server that is not on the DMZ. I have a mapped
    drive
    >> >> setup on the web server pointing to the location of
    the
    >> >> JPEG images. The other functions of the ASP app
    work
    >> fine
    >> >> (query Progress DBMS). The database management
    system
    >> is
    >> >> Progress 9.1C, and I am using the OpenLink driver.
    I
    >> can
    >> >> access the main ASP application great on the server,
    >> and
    >> >> it is able to query data directly from the Progress
    >> >> database. However, when the pop-up appears within
    the
    >> ASP
    >> >> application that shows the JPEGS that are available,
    >> >> there are no hyperlinks to those JPEG files (this
    >> should
    >> >> be the case if things are setup properly). Everyone
    >> >> (including the anonymous account for this web
    server)
    >> has
    >> >> access to the folder with the JPEGS on the file
    server.
    >> >> What might I be missing here? Both anonymous and
    >> Windows
    >> >> Integrate Authentication are checked in the Internet
    >> >> Services Manager for the properties of this new
    site.
    >> >>
    >> >> Any ideas?
    >> >>
    >> >
    >> >
    >> >.
    >> >
    >
    >
    >.
    >
    MJ Guest

  7. #6

    Default Re: ASP access via OpenLink, Progress 9.1C

    If you start a new page , and hardcode the url to that image, does it work?


    "MJ" <anonymous@discussions.microsoft.com> wrote in message
    news:069301c3a4d6$eb97da20$a301280a@phx.gbl...
    > Summary:
    >
    > -Windows Professional machines accessing ASP app via IE 6
    > -Web Server (IIS 5.0) on DMZ
    > -File Server (Windows 2000 Server) is not on DMZ
    > -ASP application needs to be able to access JPEGS on file
    > server, but currently cannot.
    > -DB Server (Windows 2000 Server), separate server from
    > file server, not on DMZ
    > -ASP app queries Progress 9.1C DB Server via OpenLink
    > driver perfectly
    > -Everything is on same LAN, just the DMZ and others on
    > different subnets
    > -The security on IIS Server is set to Windows integrated,
    > as well as anonymous.
    > -All domain users have read access to the folder that
    > contains the JPEGS on the file server
    >
    > Details:
    >
    > I have a web server setup on a DMZ with an ASP
    > application that is trying to access JPEGS on a file
    > server that is not on the DMZ. I have a mapped drive
    > setup on the web server pointing to the location of the
    > JPEG images. The other functions of the ASP app work fine
    > (query Progress DBMS). The database management system is
    > Progress 9.1C, and I am using the OpenLink driver. I can
    > access the main ASP application great on the server, and
    > it is able to query data directly from the Progress
    > database. However, when the pop-up appears within the ASP
    > application that shows the JPEGS that are available,
    > there are no hyperlinks to those JPEG files (this should
    > be the case if things are setup properly). Everyone
    > (including the anonymous account for this web server) has
    > access to the folder with the JPEGS on the file server.
    > What might I be missing here? Both anonymous and Windows
    > Integrate Authentication are checked in the Internet
    > Services Manager for the properties of this new site.
    >
    > Any ideas?
    >

    Jeff Clark Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139