Web Wiz Support and Community Forums : Moving the DB out of the wwwroot dir https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 18:53:19 +0000 Wed, 28 Jan 2004 21:52:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=9300 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Moving the DB out of the wwwroot dir : evening_grosbea wrote:DP -...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49676.html#49676 Author: dpyers
Subject: 9300
Posted: 28 January 2004 at 9:52pm

Originally posted by evening_grosbea evening_grosbea wrote:

DP - I assume you meant to type "physical path"?

<dopeslap action="uppercut" location="upside-head"> DOH !</dopeslap>

]]> Wed, 28 Jan 2004 21:52:02 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49676.html#49676 <![CDATA[Moving the DB out of the wwwroot dir : Awesome response Snapey - Thanks!...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49663.html#49663 Author: evening_grosbea
Subject: 9300
Posted: 28 January 2004 at 7:39pm

Awesome response Snapey - Thanks!]]> Wed, 28 Jan 2004 19:39:38 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49663.html#49663 <![CDATA[Moving the DB out of the wwwroot dir : To find your physical path, enter...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49643.html#49643 Author: snapey
Subject: 9300
Posted: 28 January 2004 at 5:49pm

To find your physical path, enter this in a page

   response.write(server.MapPath("/"))

This will show you the physical path to your root directory.

My hosting company has all web content in a folder called htdocs, and then parallel to this is a folder called private. So whenever I want to access a file in the private area I use something like:

strRootPath = Server.MapPath("/")
strDbPathAndName =((Left(strRootPath,len(strRootPath)-6)) & "private/wwForum.mdb")

There should be 2 lines above, but the second has wrapped so be sure to enter it all on one line.
I'm no ASP expert, but what this does is a) get the physical path to the root of the web site. Then b) find the length of that path and remove 6 (the number of characters in htdocs) This gives me the physical path to the root of my hosted web space. I can then add on the folder and database name that I am interested in.

Why go to all this trouble? Because I can use the same code on any of my sites, and the physical path may change, but I can always find my databases no matter which site it is, or which folder the asp is running in.

 

]]> Wed, 28 Jan 2004 17:49:37 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49643.html#49643 <![CDATA[Moving the DB out of the wwwroot dir : And your provider has to allow...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49569.html#49569 Author: Eftie
Subject: 9300
Posted: 28 January 2004 at 10:15am

And your provider has to allow physical path mapping and/or ../ in the servermappath function, otherwise youre stuck as well]]> Wed, 28 Jan 2004 10:15:38 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49569.html#49569 <![CDATA[Moving the DB out of the wwwroot dir : there are many ways to do it,...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49551.html#49551 Author: neotrix
Subject: 9300
Posted: 28 January 2004 at 8:45am

there are many ways to do it, there must be a file manager in ur CP, most of the file managers show you the physical path.. and there is mod as well

]]> Wed, 28 Jan 2004 08:45:33 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49551.html#49551 <![CDATA[Moving the DB out of the wwwroot dir : DP - I assume you meant to type...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49539.html#49539 Author: evening_grosbea
Subject: 9300
Posted: 28 January 2004 at 7:40am

DP - I assume you meant to type "physical path"?

Also - How can I find out what drive my site is on with my host.  Do I just contact them, or can this be accomplished using FTP or another method?

Thanks

]]> Wed, 28 Jan 2004 07:40:55 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49539.html#49539 <![CDATA[Moving the DB out of the wwwroot dir : The virtual path will look something...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49495.html#49495 Author: dpyers
Subject: 9300
Posted: 28 January 2004 at 1:17am

The virtual path will look something like "C:\somedir\somedir\mydb.mdb"]]> Wed, 28 Jan 2004 01:17:49 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49495.html#49495 <![CDATA[Moving the DB out of the wwwroot dir : instead of defining the vertual...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49469.html#49469 Author: neotrix
Subject: 9300
Posted: 27 January 2004 at 9:51pm

instead of defining the vertual path, define the physical path, and u can host it anywhere. even out side the www rote directory

]]> Tue, 27 Jan 2004 21:51:22 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49469.html#49469 <![CDATA[Moving the DB out of the wwwroot dir : How can Imap the database to a...]]> https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49468.html#49468 Author: evening_grosbea
Subject: 9300
Posted: 27 January 2004 at 9:43pm

How can I map the database to a dir outside of the wwwroot directory ?


 'Virtual path to database
 strDbPathAndName = Server.MapPath("?")

Thanks in advance

]]> Tue, 27 Jan 2004 21:43:59 +0000 https://forums.webwiz.net/moving-the-db-out-of-the-wwwroot-dir_topic9300_post49468.html#49468