Shared DB 1

[Bixarrio]

Hi.

I have a site on a free web host, but I find that the host isn't always 'up' or i get a "server too busy" error. What I want to do is upload the site to another free host (as well) and share the db between the 2 sites. I'm using ASP and ADO (no ODBC).

Please Help! _________________
Bixarrio

e = m * (c ^ 2)

 

[wushutwist]

Good Luck. What type of database are you running? If SQL Server and you can convince the one company to open port 1433 (I think) in the Firewall (not likely) then you are in business. If it is Access then you would have to convince them to setup a VPN between Hosts, not a chance in Heck.

Alternately you could write a service handler in ASP to take requests through HTTP and return the results as a delimited type (csv or something). You could also use VB to make URL connections to an ASP, this may be better than straight ASP. This sort of stuff is much better done through Java and RMI.

Wushutwist

 

[Bixarrio]

Actually, Thanks. You made me think of something.

Can't I have the db on one site, and all the dbprocessing ASP pages on the same site, and when the mirror site need db info/updates/etc., it calls the pages on the other site? _________________
Bixarrio
e = m * (c ^ 2)

 

[wushutwist]

Sure that will work fine. The problem you will run into is keeping sessions, if you use them. If you are not using sessions than the only drawback will be the increased maintance. Now you have to separate sites to worry about. Also, as I am sure you realise, if one host goes down it will still impact your site. Wushutwist

 

[Bixarrio]

Good point. If the host with the db pages goes down, both site will be useless. Hmmm. Maintenance is not too much of a problem, since most content is generated from info from the db. I add some records, and it will reflect on both sites.

Thanks. You have made some valid points, and I will have to reconsidder some options. _________________
Bixarrio
e = m * (c ^ 2)