Win32::OLE problem

This is a multi-part message in MIME format.

--===============0656879635==
Content-type: multipart/alternative;
boundary="----=_NextPart_000_0187_01C97336.6E97F350"

This is a multi-part message in MIME format.

------=_NextPart_000_0187_01C97336.6E97F350
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
=20
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:=20
$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?

Thanks in advance - dorian@uaqa.com
------=_NextPart_000_0187_01C97336.6E97F350
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: Win32::OLE problem

--===============1702513897==
Content-Type: multipart/alternative;
boundary="----=_Part_85675_24139485.1231720672581"

------=_Part_85675_24139485.1231720672581
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

2009/1/11 Dorian Winterfeld

> 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 = 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?
>


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.

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.

Cheers,
Just in

------=_Part_85675_24139485.1231720672581
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Re: Win32::OLE problem

--===============1478470740==
Content-Type: multipart/alternative;
boundary="----=_Part_100269_30003422.1231807167529"

------=_Part_100269_30003422.1231807167529
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

>
> *2009/1/11 Dorian Winterfeld
> *
>>
>> * * * **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 = 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?*
>> * *
>>
> *
>
> 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.
>
> 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.
>
> Cheers,
> Just in
> *
>
> * *
> *
>
> *
>
> *Offline you wrote:-
**
**2009/1/13 Dorian Winterfeld
* *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

------=_Part_100269_30003422.1231807167529
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

RE: Win32::OLE problem

This is a multi-part message in MIME format.

--===============2009554213==
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.=20

=20

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.

=20

From: activeperl-bounces@listserv.ActiveState.com
[mailto:activeperl-bounces@listserv.ActiveState.com] On Behalf Of Justin
Allegakoen
Sent: Monday, January 12, 2009 7:39 PM
To: activeperl@listserv.activestate.com
Subject: Re: Win32::OLE problem

=20

2009/1/11 Dorian Winterfeld

Hi,

=20

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:

=20

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

=20

line 637 is:=20
$Excel =3D Win32::OLE->new('Excel.Application', 'Quit') or
return 0;

=20

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
=20

Offline you wrote:-

2009/1/13 Dorian Winterfeld

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.....

=20

- Dorian =20



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 . . .=20

Just in


------_=_NextPart_001_01C97729.D8A46213
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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">


charset=3Dus-ascii">