problem: Stream XLS to user via ASP page

I have a page which streams an Excel spreadsheet to the user. It has worked
fine for 12mths or more, but recently I found out that it wasn't working. I
suspect the problem lies with IIS, but I'm not sure...

When the user submits a form, the page should stream the file to the user -
the user is presented with a standard Open/Save/Cancel dialog, which the
would ordinarily save to their HDD. I have updoaded the code from the live
server to my development machine (IIS5.1) - and this same code works fine.

However, on the live server (IIS6), the user is presented with the dialog
box, but rather than listing myfile.xls, it lists mypage.asp as the file to
be downloaded.

I think this must be an IIS6 issue but I don't know what. Some time before
the problem was noticed, work had been done on the live server, but AFAIK
nothing was done that was *intended* to affect this application.

Any ideas?

TIA

Chris
--
cjmnews04@REMOVEMEyahoo.co.uk
[remove the obvious bits]

Tom
Wed Oct 12 09:04:48 CDT 2005

"CJM" <cjmnews04@newsgroup.nospam> wrote in message
news:%23llRroxzFHA.3780@TK2MSFTNGP12.phx.gbl...
>I have a page which streams an Excel spreadsheet to the user. It has worked
>fine for 12mths or more, but recently I found out that it wasn't working. I
>suspect the problem lies with IIS, but I'm not sure...
>
> When the user submits a form, the page should stream the file to the
> user - the user is presented with a standard Open/Save/Cancel dialog,
> which the would ordinarily save to their HDD. I have updoaded the code
> from the live server to my development machine (IIS5.1) - and this same
> code works fine.
>
> However, on the live server (IIS6), the user is presented with the dialog
> box, but rather than listing myfile.xls, it lists mypage.asp as the file
> to be downloaded.
>
> I think this must be an IIS6 issue but I don't know what. Some time before
> the problem was noticed, work had been done on the live server, but AFAIK
> nothing was done that was *intended* to affect this application.
>
> Any ideas?

Does any of this help?
http://www.aspfaq.com/show.asp?id=2161

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserver2003/community/centers/iis/
http://mvp.support.microsoft.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS

v-wdxu
Wed Oct 12 23:38:36 CDT 2005

Hi Chris,

By default, IIS6.0 bans the execution of ASP file which is designed to
improve the server security. So I'd suggest you could check this at the web
service extension node in the IIS mmc to enable it. The steps is:
1. In IIS Manager, click the Web Service Extensions folder.
2. In the details pane, select the ASP Web service extension that you want
to enable, and then click Allow.
* To see the properties of ASP Web service extension, select an extension,
and then click Properties.

Please feel free to let me know if you have any further question on this
matter.

Best Regards,
Wei-Dong XU
Microsoft Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
It is my pleasure to be of assistance.

CJM
Fri Oct 14 09:14:13 CDT 2005


"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:%23epntXzzFHA.820@TK2MSFTNGP10.phx.gbl...
>
> Does any of this help?
> http://www.aspfaq.com/show.asp?id=2161
>

I'm not sure what the problem was but I solved it by re-doing the page using
my original technique.

However, before I tried that, I tried the approach recommended on ASPFAQ,
which *didnt* work. I had the problem where the XLS was being downloaded,
but with name of my ASP page. This is a recognised problem, but none of the
solutions recommended of that problem in the MS KB articles worked.

Since my page is now working I'm obviously not going to pursue it, but there
was clearly more to that naming problem than the KB article suggested.

Thanks

Chris