connecting to MS Access dB on network share

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

Re: connecting to MS Access dB on network share

wrote in message
news:1159895447.356498.185910@c28g2000cwb.googlegroups.com.. .
> 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
>

Server.MapPath()

Re: connecting to MS Access dB on network share

McKirahan wrote:
> wrote in message
> news:1159895447.356498.185910@c28g2000cwb.googlegroups.com.. .
> > 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
> >

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()

Re: connecting to MS Access dB on network share

mwagoner@caldrywall.com wrote:
> 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??
>
Does this help?
http://www.aspfaq.com/show.asp?id=2168

--
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.

Re: connecting to MS Access dB on network share

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_ (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.

*** Sent via Developersdex http://www.developersdex.com ***