Auto detect whether code is being executed on localhost [IIS] or ISP web server

My project involves a large number of ASP pages that reference an Access database. I am testing the system first via IIS before publishing it to the web server.

The connection string is specific to the database location i.e. C:/inetepub/.../*.mdb etc for IIS testing and //web/content/.../*.mdb etc for the web server. Therefore I have to edit all of the files before publishing, then edit them back to continue with local deevelopment. Aagh!!!

Is there a way to introduce a simple 'test' into my codee as to where the ASP is running?

I could then 'if...then...else...' etc and save loads of time.

Hope you can help.

re: Auto detect whether code is being executed on localhost [IIS] or ISP web server

easiest solution is to have the connection string on a separate file and include it on all the pages that use it with a server-side include. Then just use a different copy of that include file on the local versus the hosted site. Does that make sense? Do you need help coding that?

Jared

re: Auto detect whether code is being executed on localhost [IIS] or ISP web server

Thanks jhardman - great idea. I've also been advised to explore server.mappath as a way of detecting the host server.
I prefer the 'includes' solution because of its apparent simplicity; I've not used includes previously but I am aware of the concept so I'll give it a go.
Cheers,
Al.

re: Auto detect whether code is being executed on localhost [IIS] or ISP web server

I just had a go at <--!includes... etc without much success. I created a new ASP file that simply declares a variable named 'path' then assigned the appropriate filepath to it. Then I used s-s includes in the code of my main page and set the connection string value to 'path'.
I think I've understood the principal correctly haven't I? It's most likely a lack of experience ony part as I'm relatively new to this and have probably got some syntax wrong somewhere!
I'll have another go soon.

re: Auto detect whether code is being executed on localhost [IIS] or ISP web server

Here is an example, a file called "LAdmin.asp" being used as an include file from the top of one of my ASP pages: Hope this helps.

Jared