ASP Excel Automation for Exporting Reports

[rajeessh]

We have a Web Application developed in ASP and deployed on Win2000 server.
We have given interactive user setting and IUSR_SERVERNAME all privileges for dcomcfg
We have also given necessary privieleges for folders

Now we get a error

Server.CreateObject Access is denied.
Will it be anything that i need to still set in dcomcfg


Can anyone please help.

 

[onpnt]

most often when you get a component related error such as a object creation error as yours looks to be, the components needed are not installed on the server either correctly or at all.
What are you trying to do?
are you creating a Excel.Sheet
have you included the Response.ContentType in the page

need more details!


____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]

http://www.onpntwebdesigns.com

 

[DreXor]

what's the object that's failing?

recordset? connection? filesystem?

 

[rajeessh]

It fails for Excel Object Creation.
Says Access is denied

 

[DreXor]

Excel object? Creation?
you using filesystem to create an excel file?
using excel as a datasource?

if you set up the proper permissions on the folders, if the file was copied in after it might have residual permissions, and the folder permissions, do they include delete? cause you cant create w/o delete permissions ( at least last i knew folder structures had to be change/modify permissions )

it would be greatly beneficial for you to put up some source code, or at least more than 50 words on what you're trying to attempt, so we have something to work with to try and get you an answer.