How to read an Excel file from a network drive?

Question

I have a dotnet 2.0 C#/web application.

I am able to manually go into a network drive and get a template from that. But through my application, when I try to access this file..it says "access denied".

What to do with this ? Please help

EDIT: Will following work ?

a)Set password for "IUSR_WEBSERVER" b)And adding below line to webconfig will solve

<identity impersonate="true" userName="IUSR_WEBSERVER" password="password" /> </system.web> 

If it work, that means, we need to change IIS config..right. Is there anyother way.

Answer 1

Are you running your web application as a user that has access to this location? By default, IIS (that which hosts websites in Windows) runs under a restricted account. You could change this to a domain account that has access by changing the application pool settings.

EDIT For IIS 5 (Windows XP), there is no concept of application pools. This will help you change your user.

Answer 2

Using IIS Manager...

1) Create a new application pool and set the Identity to run as you.

2) Go to the properties of your web site and set the application pool to the application pool you just created.