how do I reference to an acces dtabase out side my WWW folder?

[Wayne...]

on my hosting acount I have 3 folders that were set up by default:
DB
LOGS
WWW
now I understand what each if for obviously, but can i reference back to the
databases location outside the www folder from a file using
..../DB/database_name.mdb ? {asssuming of course the file I am referenceing
from is in the main WWW folder)
I just want to make surfe I get this bit right and stop any weeping wailing
and gnashing of teeth lol

Wayne...

[Ray at]

You can use:

Server.MapPath("../DB/database.mdb")

Ray at home

"Wayne..." <wa***@secretwebdesign.com> wrote in message
news:40******@212.67.96.135...

on my hosting acount I have 3 folders that were set up by default:
DB
LOGS
WWW
now I understand what each if for obviously, but can i reference back to the databases location outside the www folder from a file using
.../DB/database_name.mdb ? {asssuming of course the file I am referenceing
from is in the main WWW folder)
I just want to make surfe I get this bit right and stop any weeping wailing and gnashing of teeth lol

Wayne...

[Ken Schaefer]

If you have a root folder, and both DB and WWW are off that root folder,
then you can do a little lateral coding to work out the necessary path.

root
|- DB
|- Logs
|- WWW

Put a page into WWW, and use Server.Mappath() to get the path to WWW. Then
you can lop off WWW and substitute DB.

Cheers
Ken

"Wayne..." <wa***@secretwebdesign.com> wrote in message
news:40******@212.67.96.135...
: on my hosting acount I have 3 folders that were set up by default:
: DB
: LOGS
: WWW
: now I understand what each if for obviously, but can i reference back to
the
: databases location outside the www folder from a file using
: .../DB/database_name.mdb ? {asssuming of course the file I am referenceing
: from is in the main WWW folder)
: I just want to make surfe I get this bit right and stop any weeping
wailing
: and gnashing of teeth lol
:
: Wayne...
:
:

[Wayne...]

thanks guys thats probably saved me a good bit of messing around by trial
and error. I owe you both one;)

Wayne...

"Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
news:u%***************@tk2msftngp13.phx.gbl...

If you have a root folder, and both DB and WWW are off that root folder,
then you can do a little lateral coding to work out the necessary path.

root
|- DB
|- Logs
|- WWW

Put a page into WWW, and use Server.Mappath() to get the path to WWW. Then
you can lop off WWW and substitute DB.

Cheers
Ken

"Wayne..." <wa***@secretwebdesign.com> wrote in message
news:40******@212.67.96.135...
: on my hosting acount I have 3 folders that were set up by default:
: DB
: LOGS
: WWW
: now I understand what each if for obviously, but can i reference back to
the
: databases location outside the www folder from a file using
: .../DB/database_name.mdb ? {asssuming of course the file I am referenceing : from is in the main WWW folder)
: I just want to make surfe I get this bit right and stop any weeping
wailing
: and gnashing of teeth lol
:
: Wayne...
:
:

[Jeff Cochran]

On Tue, 4 May 2004 12:42:49 +0100, "Wayne..."
<wa***@secretwebdesign.com> wrote:

on my hosting acount I have 3 folders that were set up by default:
DB
LOGS
WWW
now I understand what each if for obviously, but can i reference back to the
databases location outside the www folder from a file using
.../DB/database_name.mdb ? {asssuming of course the file I am referenceing
from is in the main WWW folder)

I personally prefer using the full path to the MDB file, and putting
the connection string in a separate ASP file used in an include. In
your case, a Server.MapPath may be required due to the hosting company
not providing a direct path.

Jeff

[Ray at]

I also use full paths instead of server.MapPath. I prefer that. I guess if
for no other reason its one or two fewer instructions to process.

Ray at work

"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:40****************@msnews.microsoft.com...

I personally prefer using the full path to the MDB file, and putting
the connection string in a separate ASP file used in an include.

[Bob Barrows [MVP]]

I prefer using MapPath because inetpub is on the c drive of my pc, the d
drive of our development server, and the e drive of our production server.

Bob

Ray at <%=sLocation%> [MVP] wrote:

I also use full paths instead of server.MapPath. I prefer that. I
guess if for no other reason its one or two fewer instructions to
process.

Ray at work

"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:40****************@msnews.microsoft.com...

I personally prefer using the full path to the MDB file, and putting
the connection string in a separate ASP file used in an include.

[Ray at]

Somewhere along the way I developed the habit of putting inetpub on D and I
force myself to be consistent with that. But, that does make my things a
bit unportable. And when I upgraded my intranet server from NT to 2000
(dual boot, not upgrade), I put W2K on drive E. It seems odd to have an OS
drive with a greater alpha value than a data drive, but oh well.

Ray at work

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:ek**************@TK2MSFTNGP12.phx.gbl...

I prefer using MapPath because inetpub is on the c drive of my pc, the d
drive of our development server, and the e drive of our production server.

Bob

Ray at <%=sLocation%> [MVP] wrote:

I also use full paths instead of server.MapPath. I prefer that. I
guess if for no other reason its one or two fewer instructions to
process.