Page not working from another computer

[=?Utf-8?B?c3Jpbml2YXM=?=]

Hi All,
My ASP.net application has to fetch data from Excel sheet.
I'm using HTML File Control to select an excel file.

I'm using Microsoft.Jet.OLEDB.4.0 provider to fetch the data from excel.
Everything is working fine on my machine.

But when my machine is accessed from other machine and trying to upload an
excel sheet 'abc.xls', it's giving following error.
"The Microsoft Jet database engine could not find the object 'C:\abc.xls'.
Make sure the object exists and that you spell its name and the path name
correctly."

i.e.
My machine (A) when accessed from Machine B
and type the url as http://A/Myapplication/default.aspx and trying to upload
the file on machine B.It's giving an error that file not found.

Thanks in advance

Srinivas

[bruce barker]

you need to write the uploaded file to disk before you try to open it.

-- bruce (sqlwork.com)

srinivas wrote:

Hi All,
My ASP.net application has to fetch data from Excel sheet.
I'm using HTML File Control to select an excel file.

I'm using Microsoft.Jet.OLEDB.4.0 provider to fetch the data from excel.
Everything is working fine on my machine.

But when my machine is accessed from other machine and trying to upload an
excel sheet 'abc.xls', it's giving following error.
"The Microsoft Jet database engine could not find the object 'C:\abc.xls'.
Make sure the object exists and that you spell its name and the path name
correctly."

i.e.
My machine (A) when accessed from Machine B
and type the url as http://A/Myapplication/default.aspx and trying to upload
the file on machine B.It's giving an error that file not found.

Thanks in advance

Srinivas

[=?Utf-8?B?c3Jpbml2YXM=?=]

Bruce,
thanks for the reply.
Can you please explain in detail?
File that's to be uploaded is already there on another computer.
what do you mean by writing to a disk?

Thanks

"bruce barker" wrote:

you need to write the uploaded file to disk before you try to open it.

-- bruce (sqlwork.com)

srinivas wrote:

Hi All,
My ASP.net application has to fetch data from Excel sheet.
I'm using HTML File Control to select an excel file.

I'm using Microsoft.Jet.OLEDB.4.0 provider to fetch the data from excel.
Everything is working fine on my machine.

But when my machine is accessed from other machine and trying to upload an
excel sheet 'abc.xls', it's giving following error.
"The Microsoft Jet database engine could not find the object 'C:\abc.xls'.
Make sure the object exists and that you spell its name and the path name
correctly."

i.e.
My machine (A) when accessed from Machine B
and type the url as http://A/Myapplication/default.aspx and trying to upload
the file on machine B.It's giving an error that file not found.

Thanks in advance

Srinivas

[=?Utf-8?B?c3Jpbml2YXM=?=]

Got it.
Thanks a lot.
Now i'm able to view it from another machine too.
I'm saving the file to disk before reading it.

Thanks again

"bruce barker" wrote:

you need to write the uploaded file to disk before you try to open it.

-- bruce (sqlwork.com)

srinivas wrote:

Hi All,
My ASP.net application has to fetch data from Excel sheet.
I'm using HTML File Control to select an excel file.

I'm using Microsoft.Jet.OLEDB.4.0 provider to fetch the data from excel.
Everything is working fine on my machine.

But when my machine is accessed from other machine and trying to upload an
excel sheet 'abc.xls', it's giving following error.
"The Microsoft Jet database engine could not find the object 'C:\abc.xls'.
Make sure the object exists and that you spell its name and the path name
correctly."

i.e.
My machine (A) when accessed from Machine B
and type the url as http://A/Myapplication/default.aspx and trying to upload
the file on machine B.It's giving an error that file not found.

Thanks in advance

Srinivas