No. The answer was that you could tell IIS what the root directory should be. There was, however, support for the idea that you couldn't have more than one local web site.
As I recall, I suggested either pointing IIS to the site you wanted to work on or swapping the entire contents of the web site directory with the site you wanted to work on. The initial conundrum - i.e. that the string to access the database needed to be different for the local computer - is resolved by putting the MDB file in the same relative position in the web sites on each machine. In your case, they were not in the same relative position: on the server it was in the root, and on the local machine it was in the sesius sub-directory of the wwwroot. Dave S ----- Original Message ----- From: GLSmyth To: [email protected] Sent: Tuesday, September 27, 2005 3:23 AM Subject: Re: [ASP] Include Virtual Not Found Dave - Actually, that is the problem I posed in the initial message in the thread. I work on more than one website locally and wanted to find a way to tell IIS that c:\Inetpub\wwwroot is not the root. I believe that the answer was that this cannot be done, but the connection string conundrum which prompted the original question was resolved, so this is no longer an issue. Cheers - george --- In [email protected], "David Smart" <[EMAIL PROTECTED]> wrote: > Don't understand you. The root of your local site is c:\Inetpub\wwwroot because that's what IIS says it is. As I see it, you are putting the site in sub-directory sesius, which is not the root of your local site, but is a first-level sub-directory from that root. > > Dave S > > ----- Original Message ----- > From: GLSmyth > To: [email protected] > Sent: Monday, September 26, 2005 10:44 PM > Subject: Re: [ASP] Include Virtual Not Found > > > Dave - > > No, the root of my local site is c:\Inetpub\wwwroot\sesius - IIS sees > the root as c:\Inetpub\wwwroot which, to my knowledge, cannot be changed. > > (The database was at the root for testing purposes and has now been > moved into a separate folder.) > > Cheers - > > george > > > --- In [email protected], "David Smart" > <[EMAIL PROTECTED]> wrote: > > I think this is the first time we've actually seen this information. > Now, I'm speculating here, but ... > > > > On your real server, the root of the web site is at > > > > d:\Inetpub\wwwroot\sesi-md.com > > > > and you have your mdb file in the root of the web site (which is > actually a terrible idea, but that's beside the point). > > > > But the root of your test web site is at > > > > c:\Inetpub\wwwroot > > > > and you have your mdb file in a sub-directory called "sesius". > > > > Why don't you have the mdb file in the root of your test site too - > i.e. directly in the wwwroot directory? > > > > Dave S > > > > ----- Original Message ----- > > From: GLSmyth > > To: [email protected] > > Sent: Friday, September 23, 2005 11:26 PM > > Subject: Re: [ASP] Include Virtual Not Found > > > > > > Shawn - > > > > Thanks for the information. However, the thing that I need to make > > the same is the local and server locations. To this extent I think > > that I just fond something that makes it academic in that it cannot > > happen regardless (sigh). > > > > This is how I currently have the connection strings in my Include > file: > > > > Dim Driver, objCommand > > > > ' Use this one for local development > > Driver = "Provider=Microsoft.Jet.OLEDB.4.0;Data > > Source=c:\Inetpub\wwwroot\sesius\Web.mdb" > > > > ' Use this one on the server > > 'Driver = "Provider=Microsoft.Jet.OLEDB.4.0;Data > > Source=d:\Inetpub\wwwroot\sesi-md.com\Web.mdb" > > > > > > I only have a single drive, but this could be dealt with by adding a > > D: drive to my machine. The real sticker, however, is the folder that > > is on the remote machine - "sesi-md.com". I spent close to a week (on > > and off) trying to get IIS to work on my new XP maching here at work. > > I got .htm extension pages to work, but anything with .asp was > > telling me strange things, like I had the wrong scripting language and > > improper permissions. I did everything but reformat the drive that > > was suggested. The solution which dropped into my lap accidentally > > was that the dot in the folder name "sesi-md.com" was causing the > > problems. As soon as I changed the folder name to "sesius" everything > > worked just fine. Go figure. > > > > So the bottom line is that regardless what I do anywhere else, there > > is no way that I can include "sesi-md.com" as a directory name > > locally, so I will always have to have two separate connection > > strings, thus the local and remote sites will always have to have > > differences. This being the case, I will just have to make do with > > either remembering to change the pointer to the Include file if I > > decide to use "virtual" or (better yet) just go ahead and use "file" > > and deal with the consequences in case the location of a folder needs > > to change. > > > > Oh well, thanks for all of the information that has come my way, I do > > appreciate it and the thought process has helped me learn. > > > > Cheers - > > > > george > > > > > > --- In [email protected], "Shawn K. Hall" > > <[EMAIL PROTECTED]> wrote: > > > Hi George, > > > > > > > It would be great if someone a whole lot smarter > > > > than me had a way of doing this. > > > > > > It sounds like what you're wanting to do is simulate the server > folder > > > dynamics locally so you don't have to duplicate content and risk > > > problems in change management. > > > > > > If so, use different folders off of root for the include folders > (say, > > > one uses "/one" and the other uses "/two"), then map these > folders as > > > virtual directories of the same name from root. Then, when you hit a > > > page with a virtual include from root it'll hit the correct folder. > > > Here's an example: > > > > > > Assuming the following two sites: > > > > > > Site1 (d:\my websites\site one\): > > > /one/dbconn.asp > > > /file.asp > > > > > > Site2 (d:\my websites\site two\): > > > /two/dbconn.asp > > > /file.asp > > > > > > Site1 file.asp: > > > <!--#include virtual="/one/dbconn.asp" --> > > > > > > Site2 file.asp: > > > <!--#include virtual="/two/dbconn.asp" --> > > > > > > Now in IIS map the following folders as virtual folders: > > > d:\my websites\site one\one\ => /one/ > > > d:\my websites\site two\two\ => /two/ > > > > > > Now, under localhost you'll have the following folders: > > > http://localhost/site%20one/ > > > http://localhost/one/ > > > http://localhost/site%20two/ > > > http://localhost/two/ > > > > > > And if you hit either: > > > http://localhost/site%20one/file.asp > > > http://localhost/site%20two/file.asp > > > ...it'll "include" the correct file from the appropriate includes > > > folder. > > > > > > Regards, > > > > > > Shawn K. Hall > > > http://12PointDesign.com/ > > > http://ReliableAnswers.com/ > > > > > > '// ======================================================== > > > Be consistent - but don't do it all the time. > > > > > > > > > > > --------------------------------------------------------------------- > > Home : http://groups.yahoo.com/group/active-server-pages > > --------------------------------------------------------------------- > > Post : [email protected] > > Subscribe : [EMAIL PROTECTED] > > Unsubscribe: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > > > > > > > > SPONSORED LINKS Active server page web hosting Active server page > hosting Active server pages > > Active server page asp Active server page training > > > > > > > ------------------------------------------------------------------------------ > > YAHOO! GROUPS LINKS > > > > a.. Visit your group "active-server-pages" on the web. > > > > b.. To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service. > > > > > > > ------------------------------------------------------------------------------ > > > > > > > > [Non-text portions of this message have been removed] > > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [email protected] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > > > > SPONSORED LINKS Active server page web hosting Active server page hosting Active server pages > Active server page asp Active server page training > > > ------------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > a.. Visit your group "active-server-pages" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > ------------------------------------------------------------------------------ > > > > [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "active-server-pages" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
