Data driven website for multiple region.

hi,

I have 50 pages most of them are data driven pages from database using asp /sql 2000. This is for a particular region.

Now I have to plan for another region with the same number of pages but only the content from the database will change.

regions will be identified by different domain names.

How can i do it?

Shall i go for different database for each region and assign the connect string the moment user request a page? if this is the best method how can i assign the connect string when user requests a page.

thanks in advance
raj

Your idea of using two different databases and varying the connection string at the different domains sounds like a good idea to me. If I understand correctly, you want to use the same set of dynamic pages on two different servers to display content based on the connection string at the different locations.

I don't use asp myself, but I am familiar with it. I would think that the simplest way to do it would be to have the connection strings inside files that you could include at the top of all your dynamic pages that access the databases.

For both of the sites you could have a file perhaps called "database.asp" in an include directory and all your dynamic pages could have something like this at the top:


Then you could use two different files named "database.asp" - one for each site with one containing something like:

and the other:

That way the only difference between the two sets of pages would be the contents of the "database.asp" file at the two different locations.