This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C5DBD9.D060ACF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I'm trying to write an import utility for a web app that I am developing =
and I'm using an Excel spreadsheet to hold the data to be imported.
I'm using ODBC and this is my connection string--
"Driver=3D{Microsoft Excel Driver (*.xls)};Dbq=3D" + =
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
------=_NextPart_000_0008_01C5DBD9.D060ACF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>I'm trying to write an import utility =
for a web app=20
that I am developing and I'm using an Excel spreadsheet to hold the data =
to be=20
imported.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm using ODBC and this is my =
connection=20
string--</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>
<P><FONT face=3DArial size=3D2>"Driver=3D{Microsoft Excel Driver =
(*.xls)};Dbq=3D" +=20
HttpContext.Current.Server.MapPath(".//" + csv_store_read);"</FONT></P>
<P><FONT face=3DArial size=3D2>where csv_store_read is the directory =
where the Excel=20
file is.</FONT></P>
<P><FONT face=3DArial size=3D2>My application has to use a user account =
other than=20
the anonymous internet account due to the requirements of the external =
system=20
that it is accessing. I also have Impersonate set to true in the =
Web.config=20
file.</FONT></P>
<P><FONT face=3DArial size=3D2>I've also hard coded the file path to =
point to the=20
file on the local machine and neither are working. I keep getting the =
following=20
error:</FONT></P>
<P><FONT face=3DArial size=3D2><EM>[Microsoft][ODBC Excel Driver] Disk =
or network=20
error.</EM></FONT></P>
<P><FONT face=3DArial size=3D2>This works fine on my Windows 2000 =
machine so I know=20
it has something to do with security but I've tried everything I can =
think of to=20
no avail.</FONT></P>
<P><FONT face=3DArial size=3D2>Any ideas as to what I am =
missing?</FONT></P>
<P><FONT face=3DArial size=3D2>TIA,</FONT></P>
<P><FONT face=3DArial size=3D2>Bill =
Youngman</FONT></P></DIV></BODY></HTML>
------=_NextPart_000_0008_01C5DBD9.D060ACF0--