469,332 Members | 7,058 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,332 developers. It's quick & easy.

Issue with reading data from remote excel sheet

ammoos
100 100+
Hi Friends,

I need to read data from an excel sheet. I am keeping this excel sheet in a remote machine. I am using OLEDB connection to read the data from this excel sheet. But when I am trying to read the data, then I am getting the error message “It is already opened exclusively by another user, or you need permission to view its data.” I am sure the file is not opened by another user. Then may I know what I have to do for getting permission to read data. Please help me as soon as possible.

Thanks

Ammoos
Dec 22 '09 #1
4 3190
semomaniz
210 Expert 100+
Please post your code.
Dec 22 '09 #2
Frinavale
9,735 Expert Mod 8TB
Either you have opened a connection to the file previously and forgot to close it (or someone else is using the file at the same time you are)...or your permissions are incorrect.

By default ASP.NET websites are run using an anonymous user account. This account has restricted permissions and usually is not allowed to read files off of other computers on the network.

You could look into increasing the permissions for this user account (not really recommended) or you could look into using impersonation (google it).

-Frinny
Dec 22 '09 #3
ammoos
100 100+
Thanks for your reply Frinny
Jan 1 '10 #4
HI ammoos,

How you resolved the issue. Iam also facing the same problem. Kindly provide the Solution ASAP.

Thanks in advance.
May 11 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Steven Stewart | last post: by
9 posts views Thread by dba123 | last post: by
1 post views Thread by =?Utf-8?B?ZmhpbGxpcG8=?= | last post: by
1 post views Thread by =?Utf-8?B?QWRyaWFuTW9ycmlz?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.