469,926 Members | 1,718 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Acessing mdb file from a network share!!

Jay
Hello,

Iam trying to access a mdb file from a shared drive \\mycomputer\files from
ASP.NET and OLEDB.

It works locally
Computer A hosts IIS/ASP.Net.
Files reside in ComputerB under a network share.

Web.config has the following-
1. One which works-
<add key="NEWVIP" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=c:\inetpub\wwwroot\clients\newvip\database\ vip.mdb;" />

2. One which does not work-
<add key="NEWVIP" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=\\computerA\\files\newvip\database\vip.mdb; " />

Thanks for your help.
jay
Nov 18 '05 #1
2 4622
Hi Jay,

"Jay" <pr********@atginc.com> wrote in message
news:uE**************@TK2MSFTNGP10.phx.gbl...
Hello,

Iam trying to access a mdb file from a shared drive \\mycomputer\files from ASP.NET and OLEDB.

It works locally
Computer A hosts IIS/ASP.Net.
Files reside in ComputerB under a network share.

Web.config has the following-
1. One which works-
<add key="NEWVIP" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=c:\inetpub\wwwroot\clients\newvip\database\ vip.mdb;" />

2. One which does not work-
<add key="NEWVIP" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=\\computerA\\files\newvip\database\vip.mdb; " />


The aspnet account under which asp.net application is run has not enough
privileges to access the file share.
You will have to run your asp.net application under domain account that has
access to file share.
You might create an account with same name/password on both computers or use
a domain account.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
Nov 18 '05 #2
Try this knowledge base article...
307901: INFO: Permissions to Connect to a Remote Access Database from
ASP.NET
http://support.microsoft.com/default...Product=aspnet
-
Peter O'Reilly
Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Jay Mack | last post: by
7 posts views Thread by Frank Rizzo | last post: by
9 posts views Thread by Andrew Shitov | last post: by
3 posts views Thread by Michel Smit | last post: by
reply views Thread by =?Utf-8?B?UGhpbCBKb2huc29u?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.