This is a multi-part message in MIME format.
--============== 09554213==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C97729.D8A46213"
This is a multi-part message in MIME format.
------_=_NextPart_001_01C97729.D8A46213
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
When you install IIS6, it removes read/execute permission for the
IUSR_XXXX user from lots of places.
You could create a separate site or virtual folder and have it run under
a different user id. Be sure you understand the security ramifications
of this however.
From: activeperl-bounces [at] listserv.ActiveState.com
[mailto:activeperl-bounces [at] listserv.ActiveState.com] On Behalf Of Justin
Allegakoen
Sent: Monday, January 12, 2009 7:39 PM
To: activeperl [at] listserv.activestate.com
Subject: Re: Win32::OLE problem
2009/1/11 Dorian Winterfeld <dorian [at] uaqa.com>
Hi,
I have a Web based Win32::OLE script that uses Excel on
the server side. It has been working happily for years on a Win2000
server running Excel2000. We recently upgraded to Win2003/Excel2003 and
I now get the following error from the script:
Win32::OLE(0.1709) error 0x80070005: "Access is denied"
at create_worksheet_lib.plx line 637
eval {...} called at create_worksheet_lib.plx line 637
line 637 is:
$Excel =3D Win32::OLE->new('Excel.Application', 'Quit') or
return 0;
This appears to be a permissions problem as nothing has
changed in the script. Any Windows gurus out there that might be able
to help trouble shoot this?
=09
=09
Sounds as if the IIS limited access web account and its
settings in Win2K3 are preventing you from creating the Excel file in
the desired server side directory.
=09
Write the file to a shared drive where Everyone has
Write perms. You will of course have to evaluate the security risks this
may present to your setup.
=09
Cheers,
Just in
=09
=09
<http://listserv.ActiveState.com/mailman/mysubs>
Offline you wrote:-
2009/1/13 Dorian Winterfeld <dorian [at] uaqa.com>
Thanks Justin, I did try setting the output folder to
everyone/full-control but that didn't do it. It seems that in this case
"Access is denied" because Win32::OLE doesn't have access to Excel.
It's failing when it tries to create a new OLE Excel object. At least
that is what I think. I set the Excel permissions to
everyone/full-control as well but that didn't do it either. So I am
stuck for now.....
- Dorian
My apologies. I did this years ago and have only just had my memory
jolted. Calling Win32::OLE on a server from a client if you think about
it is a serious security threat (think about getting macros to execute
server side). I do remember writing ASPs on Win2K with IIS 5 and then
migrating to Win2K3 with a whole load of problems because the newer IIS
(6) was locked down a lot more. My guess is IIS 5 allowed calling of
Win32::OLE whereas IIS6 doesnt.
I was able to overcome IIS6 by using the Spreadsheet::WriteExcel and
SpreadSheel::ReadExcel modules. These modules will require installation
on your web server, but they do run on *nix if thats any consolation.
The bad news is of course moving forward would mean a rewrite of your
script. Now theres a happy new year for you . . .
Just in
------_=_NextPart_001_01C97729.D8A46213
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif" ;
color:#1F497D'>When you install IIS6, it removes read/execute permission =
for
the IUSR_XXXX user from lots of places. <o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif" ;
color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif" ;
color:#1F497D'>You could create a separate site or virtual folder and =
have it
run under a different user id. Be sure you understand the security
ramifications of this however.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif" ;
color:#1F497D'><o:p> </o:p></span></p>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' >From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' >
activeperl-bounces [at] listserv.ActiveState.com
[mailto:activeperl-bounces [at] listserv.ActiveState.com] <b>On Behalf Of =
</b>Justin
Allegakoen<br>
<b>Sent:</b> Monday, January 12, 2009 7:39 PM<br>
<b>To:</b> activeperl [at] listserv.activestate.com<br>
<b>Subject:</b> Re: Win32::OLE problem<o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<div>
<blockquote style=3D'border:none;border-left:solid #CCCCCC =
1.0pt;padding:0in 0in 0in 6.0pt;
margin-left:4.8pt;margin-right:0in'>
<div>
<blockquote style=3D'border:none;border-left:solid black =
1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin- bottom:5.0pt'=
>
<div>
<p class=3DMsoNormal><b>2009/1/11 Dorian Winterfeld <<a
href=3D"mailto:dorian [at] uaqa.com" =
target=3D"_blank">dorian [at] uaqa.com</a>></b><o:p></o:p></p>
<div>
<div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> Hi,</span></b=
><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b> </b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> I
have a Web based Win32::OLE script that uses Excel on the server =
side. It
has been working happily for years on a Win2000 server running =
Excel2000.
We recently upgraded to Win2003/Excel2003 and I now get the following =
error
from the script:</span></b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b> </b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> Win32::OLE(0.=
1709)
error 0x80070005: "Access is denied" at =
create_worksheet_lib.plx line
637<br>
eval {...} called at create_worksheet_lib.plx line =
637</span></b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b> </b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> line
637 is: <br>
$Excel =3D Win32::OLE->new('Excel.Application', 'Quit') or return =
0;</span></b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b> </b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> This
appears to be a permissions problem as nothing has changed in the =
script.
Any Windows gurus out there that might be able to help trouble shoot =
this?</span></b><o:p></o:p></p>
</div>
</div>
</div>
<p class=3DMsoNormal><b><br>
<br>
Sounds as if the IIS limited access web account and its settings in =
Win2K3 are
preventing you from creating the Excel file in the desired server side
directory.<br>
<br>
Write the file to a shared drive where Everyone has Write perms. You =
will of
course have to evaluate the security risks this may present to your =
setup.<br>
<br>
Cheers,<br>
Just in</b><o:p></o:p></p>
<p class=3DMsoNormal><b><a =
href=3D"http://listserv.ActiveState.com/mailman/mysubs"
target=3D"_blank"><br>
<br>
</a></b><o:p></o:p></p>
</blockquote>
</div>
</blockquote>
</div>
<p class=3DMsoNormal><b>Offline you wrote:-<br>
<br>
2009/1/13 Dorian Winterfeld <<a =
href=3D"mailto:dorian [at] uaqa.com">dorian [at] uaqa.com</a>></b><o:p></o:p></p=
>
<div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> Thanks
Justin, I did try setting the output folder to everyone/full-control but =
that
didn't do it. It seems that in this case "Access is =
denied"
because Win32::OLE doesn't have access to Excel. It's failing =
when
it tries to create a new OLE Excel object. At least that is =
what I
think. I set the Excel permissions to everyone/full-control as =
well but
that didn't do it either. So I am stuck for =
now.....</span></b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b> </b><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'> -
Dorian </span></b><o:p></o:p></p>
</div>
<p class=3DMsoNormal><br>
<br>
My apologies. I did this years ago and have only just had my memory =
jolted.
Calling Win32::OLE on a server from a client if you think about it is a =
serious
security threat (think about getting macros to execute server side). I =
do
remember writing ASPs on Win2K with IIS 5 and then migrating to Win2K3 =
with a
whole load of problems because the newer IIS (6) was locked down a lot =
more. My
guess is IIS 5 allowed calling of Win32::OLE whereas IIS6 doesnt.<br>
<br>
I was able to overcome IIS6 by using the Spreadsheet::WriteExcel and
SpreadSheel::ReadExcel modules. These modules will require installation =
on your
web server, but they do run on *nix if thats any consolation. The bad =
news is
of course moving forward would mean a rewrite of your script. Now theres =
a
happy new year for you . . . <br>
<br>
Just in<o:p></o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01C97729.D8A46213--
--============== 09554213==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
--============== 09554213==--
