Ask a Question related to ASP Database, Design and Development.
-
MJ #1
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
-
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... -
#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... -
#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: ... -
#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:... -
#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... -
Jeff Clark #2
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
-
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.
message>-----Original Message-----
>does it show up as a broken image, or no image at all.
>
>
>"MJ" <anonymous@discussions.microsoft.com> wrote inIE 6>news:069301c3a4d6$eb97da20$a301280a@phx.gbl...>> Summary:
>>
>> -Windows Professional machines accessing ASP app viafile>> -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 onintegrated,>> 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 Windowsfine>> 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 workis>> (query Progress DBMS). The database management systemcan>> Progress 9.1C, and I am using the OpenLink driver. Iand>> access the main ASP application great on the server,ASP>> it is able to query data directly from the Progress
>> database. However, when the pop-up appears within theshould>> application that shows the JPEGS that are available,
>> there are no hyperlinks to those JPEG files (thishas>> be the case if things are setup properly). Everyone
>> (including the anonymous account for this web server)Windows>> access to the folder with the JPEGS on the file server.
>> What might I be missing here? Both anonymous and>>> Integrate Authentication are checked in the Internet
>> Services Manager for the properties of this new site.
>>
>> Any ideas?
>>
>
>.
>Guest
-
Jeff Clark #4
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.
>> message> >-----Original Message-----
> >does it show up as a broken image, or no image at all.
> >
> >
> >"MJ" <anonymous@discussions.microsoft.com> wrote in> IE 6> >news:069301c3a4d6$eb97da20$a301280a@phx.gbl...> >> Summary:
> >>
> >> -Windows Professional machines accessing ASP app via> file> >> -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> integrated,> >> 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> fine> >> 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> is> >> (query Progress DBMS). The database management system> can> >> Progress 9.1C, and I am using the OpenLink driver. I> and> >> access the main ASP application great on the server,> ASP> >> it is able to query data directly from the Progress
> >> database. However, when the pop-up appears within the> should> >> application that shows the JPEGS that are available,
> >> there are no hyperlinks to those JPEG files (this> has> >> be the case if things are setup properly). Everyone
> >> (including the anonymous account for this web server)> Windows> >> access to the folder with the JPEGS on the file server.
> >> What might I be missing here? Both anonymous and> >> >> Integrate Authentication are checked in the Internet
> >> Services Manager for the properties of this new site.
> >>
> >> Any ideas?
> >>
> >
> >.
> >
Jeff Clark Guest
-
MJ #5
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 & " [" &
filesys.FileExists(sFullPath) & "]<br>"
if not filesys.FileExists(sFullPath) then
sFullPath = "#"
end if
else
sFullPath="#"
end if
GetImagePath = sFullPath
end function
from>-----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.
>>>> message>> >-----Original Message-----
>> >does it show up as a broken image, or no image at all.
>> >
>> >
>> >"MJ" <anonymous@discussions.microsoft.com> wrote in>> IE 6>> >news:069301c3a4d6$eb97da20$a301280a@phx.gbl...
>> >> Summary:
>> >>
>> >> -Windows Professional machines accessing ASP app via>> file>> >> -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>> >> server, but currently cannot.
>> >> -DB Server (Windows 2000 Server), separate serverOpenLink>> >> file server, not on DMZ
>> >> -ASP app queries Progress 9.1C DB Server viaon>> >> driver perfectly
>> >> -Everything is on same LAN, just the DMZ and othersthat>> integrated,>> >> different subnets
>> >> -The security on IIS Server is set to Windows>> >> as well as anonymous.
>> >> -All domain users have read access to the folderdrive>> >> 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 mappedthe>> >> setup on the web server pointing to the location ofwork>> >> JPEG images. The other functions of the ASP appsystem>> fine>> >> (query Progress DBMS). The database managementI>> is>> >> Progress 9.1C, and I am using the OpenLink driver.the>> can>> and>> >> access the main ASP application great on the server,>> >> it is able to query data directly from the Progress
>> >> database. However, when the pop-up appears withinserver)>> ASP>> should>> >> application that shows the JPEGS that are available,
>> >> there are no hyperlinks to those JPEG files (this>> >> be the case if things are setup properly). Everyone
>> >> (including the anonymous account for this webserver.>> has>> >> access to the folder with the JPEGS on the filesite.>> Windows>> >> What might I be missing here? Both anonymous and>> >> Integrate Authentication are checked in the Internet
>> >> Services Manager for the properties of this new>>> >>
>> >> Any ideas?
>> >>
>> >
>> >
>> >.
>> >
>
>.
>MJ Guest
-
Jeff Clark #6
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



Reply With Quote

