Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-02-27 : 15:25:00
|
| I normally have the development webs on my laptop access the live databases hosted on the internet. However, when I am off the internet, I'd like these same ASP webs to access the SQL server on my laptop.I'd like to not manually edit any code to change sql servers when I'm off the internet. Here's my thoughts to get around this problem:An application variable is used to reference the database, so it seems that I could modify the database reference string in the global.asa application_onstart routine to check for the existance of default SQL server and substitute my laptop server if the default server is down.What's the minimal ADO code to test for a server being up?Sam |
|
|
|
|
|
ASP FIND ALTERNATE DATABASE