Excel automation in vb hangs asp page.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: jbhan (jbhan_at_discussions.microsoft.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 13:51:05 -0800

Hi,

I have an asp application which was recently deployed on a windows 2003
server from a windows 2000 server.
The application has some reports which are run in word, csv , html, excel
etc.
After the deployment all the asp pages are coming up including the reports
except for the excel one.

The excel report is generated using Excel automation from a visual basic 6.0
component which then gets called in the asp page.
Everytime I try to access the report the page just hangs and nothing shows
up.

The only error logged in the event log is

Error: The Template Persistent Cache initialization failed for Application
Pool 'DefaultAppPool' because of the following error: Could not create a Disk
Cache Sub-directory for the Application Pool. The data may have additional
error codes.

I don't have problem accessing any other asp pages just this one.
Does any one have an idea what might be causing this? Any help or pointer
would be greatly appreciated!

Thanks,
jbhan

Relevant Pages

  • Re: why>?
    ... That's nice when running things on the server. ... Excel VBA is a disease and a threat to national security. ... an add-in from the local drive, ... OK, details are optional, so reports don't have to include details. ...
    (microsoft.public.excel)
  • Re: Operator is not valid for type DBNull and type Date
    ... > fully convert it to ASP .NET. ... You are still using all the classic ASP ... > problem was saving to Excel. ... Lots of the reports we create, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Katalog mit Bildern erstellen : WIE?
    ... Entweder steht der Dateiname des Bildes mit in der Excel ... Tabelle, oder die Bilder haben eindeutige Dateinamen wie z.B. ... Wenn dein Server ASP unterstützt, kannst du die Excel Tabelle oder besser ... per ASP kannst du dann die Tabelle auf einer Webseite ausgeben. ...
    (microsoft.public.de.frontpage)
  • Re: Operator is not valid for type DBNull and type Date
    ... fully convert it to ASP .NET. ... You are still using all the classic ASP ... problem was saving to Excel. ... Lots of the reports we create, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problems displaying Excel on aspx page
    ... On a Windows 2003 server, you may create a second application pool ... Assign that pool to the asp site that you want to write local files. ... interfere with starting the Excel engine. ...
    (microsoft.public.dotnet.framework.aspnet)