i remove server.mapPath() like this:
<%
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Z:\DB\access.mdb;"
set conn = CreateObject("ADODB.Connection")
conn.open cst
%>
the next error is this:
Microsoft JET Database Engine error '80004005'
Could not find file 'Z:\DB\access.mdb'.
/cn.asp, line 4
"Steven Burn" <> wrote in message
news:...
> The problem is, you've used a physical path, and not a virtual one, just
as
> the message says.....
>
> Either remove Server.MapPath(), or change the path to a virtual one.....
> --
>
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
>
> "A P" <> wrote in message
> news:#...
> > I receive an error like this:
> > Server.MapPath() error 'ASP 0172 : 80004005'
> >
> > Invalid Path
> >
> > /conn.asp, line 2
> >
> > The Path parameter for the MapPath method must be a virtual path. A
> physical
> > path was used.
> >
> >
> >
> > the conn.asp code :
> >
> > <%
> > cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
> > Server.MapPath("Z:\AccessDB\access.mdb")
> > set conn = CreateObject("ADODB.Connection")
> > conn.open cst
> > %>
> >
> > Do I need to locate the mdb file inside the wwwroot? how about enable
web
> > sharing on the Z:\AccessDB, is this required even though I set change
> > permission on IUSR account?
> >
> >
>
>