Can't Read Excel File (OleDb) w/ ASP.NET Impersonation

C

cmay

Problem:
When impersonation is set in the web.config file, I cannot establish an
OLEDB connection to the database from my ASP.NET v1.1 application.
(Unspecified Error. Stack trace shows it happens on the ProcessResults
method within the OleDB Provider)

Cause:
Both of these KB articles from MS describe the problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827190
http://support.microsoft.com/default.aspx?scid=kb;EN-US;825738

The problem, is that on my development machine, there is no
C:\Documents and Settings\ServerName folder (the folder they say needs
to have security changes made to it).

I am not using impersonation w/ Windows authentication, I am using
forms auth, and I don't impersonate the logged in user, I supply the
user account to impersonate in the web.config file:

<identity impersonate="true" username="asdf" password="fdsa" />


Anyone know what I can do to fix this? My only work around is to turn
off impersonation for the pages that need to access this resource, but
that is a poor solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top