Can't open Exel spread*** using oledb open method in Windows XP sp2
- From: "Bill Youngman" <wyoungman@xxxxxxxxxxxx>
- Date: Tue, 1 Nov 2005 11:33:44 -0500
I am writing a web application as a administrative
front end to a document management system. One of the functions that I am
developing is the ability to import new users into the system via an Excel
spread***. The specific error code I am getting (if you want to call it
specific) is 0x80004005 and the message is 'unspecified error'.
My connection string is
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ HttpContext.Current.Server.MapPath(".//" + csv_store_read) + ";Extended
Properties=Exel 11.0;HDR=Yes"
Where HttpContext.Current.Server.MapPath(".//" + csv_store_read)
is the physical path to the file. The spread*** resides in a local folder
on the users machine and then when the import the file will be copied to the web
server. I've ensured that the folder on the server has the internet account user
configured for full access. I also read a couple of threads that said to set up
the Windows system directory to have the internet user account assigned to it as
well.
I also have impersonate set to true in the
web.config file
Nothing is working I keep getting this
error.
Any help/suggestions will be GREATLY
appriciated.
Thanks,
Bill Youngman
- Prev by Date: Re: cannot get column information from OLE DB provider"MSDASQL"
- Next by Date: Oracle Resultset from Stored Procedure
- Previous by thread: Re: .NET data provider or OLEDB provider?
- Next by thread: Oracle Resultset from Stored Procedure
- Index(es):
Loading