ASP.NET OleDbConnection - Databases

> I am trying
>
> dbStr = Server.MapPath("../TestDatabase.mdb")
> Response.write("db string " & dbStr)

do a response.write(server.mappath("test.asp")) then that will show you the
full path. Use that path to find the path to your db. For example if it
returns something like "d:/users/blah/html/test.asp" then you could change
it to "d:/users/database/db.mdb" and set your db string to this directly.

Dan, I tried this early on, but I do not understand why it returns my hard
disk directory when I am using a Web server. I expected something referring
to the Web server.

Also, my book only uses examples referring to hard disk directories.

Trevor

"Dan" <nospam@nospam.com> wrote in message
news:rxCJa.8739$Kg7.6955@nwrdny01.gnilink.net...
> > I am trying
> >
> > dbStr = Server.MapPath("../TestDatabase.mdb")
> > Response.write("db string " & dbStr)
>
> do a response.write(server.mappath("test.asp")) then that will show you
the
> full path. Use that path to find the path to your db. For example if it
> returns something like "d:/users/blah/html/test.asp" then you could change
> it to "d:/users/database/db.mdb" and set your db string to this directly.
>
>
>
>

"trevor oakley" <to006e7245@blueyonder.co.uk> wrote in message
news:wnGJa.322$vn5.269@news-binary.blueyonder.co.uk...
> Dan, I tried this early on, but I do not understand why it returns my hard
> disk directory when I am using a Web server. I expected something
referring
> to the Web server.

No, mappath returns the "physical location" ... that is how things look to
your *harddrive*... not your web paths.

>
> Also, my book only uses examples referring to hard disk directories.



Try microsoft.public.inetserver.asp.general on msnews.microsoft.com.