connecting to MS Access dB on network share

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mwagoner@caldrywall.com - 03 Oct 2006 18:10 GMT

I am trying to connect to a MS Access dB on a network share using the
following syntax but it doesn't work:

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\Calsj1\PMAPPS\pmdata.mdb"

If I move the dB to a location on my IIS it works fine and I can access
the dB.

I am running IIS 6.0 on Win2k3 server.

What am I doing wrong??

THanks

Reply to this Message

McKirahan - 03 Oct 2006 18:28 GMT

> I am trying to connect to a MS Access dB on a network share using the
> following syntax but it doesn't work:
[quoted text clipped - 10 lines]
>
> THanks

Server.MapPath()

Reply to this Message

mwagoner@caldrywall.com - 03 Oct 2006 19:01 GMT

> > I am trying to connect to a MS Access dB on a network share using the
> > following syntax but it doesn't work:
[quoted text clipped - 10 lines]
> >
> > THanks

I tried this:

strConnect = "PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=
"Server.MapPath("\\calsj1\pmapps\pmdata.mdb")

and still didn't work? I am getting an Internal 500 error...

?????

> Server.MapPath()

Reply to this Message

Bob Barrows [MVP] - 03 Oct 2006 19:13 GMT

> I am trying to connect to a MS Access dB on a network share using the
> following syntax but it doesn't work:
[quoted text clipped - 8 lines]
>
> What am I doing wrong??

Does this help?
http://www.aspfaq.com/show.asp?id=2168

Signature

Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Reply to this Message

Özer KAYHAN - 04 Oct 2006 21:18 GMT

Hi,
Try to uncheck

"Internet Explorer / Tools / Internet Options / Advanced / Browsing ->
Show friendly HTTP Error Messages" option.

Then get the error source correctly.

I think your IUSR_<Machine_Name> (Internet Guest Account) does not have
required access right to read from network share. If it's a must to
share mdb on the network, move it to your server then share it on that.

I hope these help to u. Bye.

Reply to this Message

Webmaster Forum / ASP / Database Access / October 2006

connecting to MS Access dB on network share