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