Can't open Excel spreadsheet from within .Net web app on Windows XP

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm trying to write an import utility for a web app that I am developing and
I'm using an Excel spread*** to hold the data to be imported.

I'm using ODBC and this is my connection string--

"Driver={Microsoft Excel Driver (*.xls)};Dbq=" +
HttpContext.Current.Server.MapPath(".//" + csv_store_read);"

where csv_store_read is the directory where the Excel file is.

My application has to use a user account other than the anonymous internet
account due to the requirements of the external system that it is accessing.
I also have Impersonate set to true in the Web.config file.

I've also hard coded the file path to point to the file on the local machine
and neither are working. I keep getting the following error:

[Microsoft][ODBC Excel Driver] Disk or network error.

This works fine on my Windows 2000 machine so I know it has something to do
with security but I've tried everything I can think of to no avail.

Any ideas as to what I am missing?

TIA,

Bill Youngman


.

Quantcast