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

 

[Miha Markic]

Hi 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;" />

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.

 

[Peter O'Reilly]

Try this knowledge base article...
307901: INFO: Permissions to Connect to a Remote Access Database from
ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;307901&Product=aspnet
-
Peter O'Reilly