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] ------------------------ 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/
