Another day, another dollar
So once again, the server was down. I'm sorry, but I finally gots it workin'! Basically, SQL Server out of nowhere decided that it didn't want to be called "local" anymore, even though that is its name, and decided it wanted to be called main just like the entire computer. So, even though it had always worked under the name local, I finally in desperation tried accessing it in my asp code as main instead of its real name local ... and main worked! Dont' ask how, but I'd already reinstalled asp.net, frontpage, sql (about ten times) trying to fix this whole thing. Iain said switch to linux, but this sort of thing isn't necessarily something that linux wouldn't have issues with as well.
So, that is that. All the pages should be working again, let me know if you find any errors.
Adm.

Linux would 100% solve your problem because you would be able to run apache, php, and postrgres all w/o using %100 of the harware behind your little p2-400. BUT either way, the naming thing makes perfect sense - local (or localhost) is a loop-back address from a computer to itself. You can also call the computer's name from itself and get the same response. Not sure why your default loopback went down though
go linux
-joe
See, he agrees with me. Linux, spork, it's where it's at.
--Fiend
except that thespork and its affiliates are ASP powered and windows definitely monkeywhores linux in that department
glad to see its workin again
I'm hoping that monkeywhore is a good word ... but Joe suggested PHP above, which would be the replacement ...
monkeywhore (mung' ke hôr) v. slang
1. to 0wn
2. to make something one's "bitch"
etc.
well you could use sun's sun one platform to serve asp out of linux: (http://developer.chilisoft.com/downloads/default.asp) - You can also use mono (www.go-mono.com) and snap it into apache - (www.go-mono.com/asp-net)
that way linux could still "monkeywhore" any windows box.
plus - PHP is far supperior and faster - and with PHP5 slated for a summer release it looks very promising.
(not to mention that MySql can run with a bout a 2mb memory footprint!!!!! you kill yourself running MsSQL because it runs a bunch of enterprise level stuff *that you do not need* all you need is simple fetch capabilities)
back to homework
-joe
Well, mono isn't finished. They don't have all the classes done. I don't know abot Sun One and I've never used a Sun OS. But I'm actually quite fine with my Windows 2000 Server, it's worked for the past 3 years, and I haven't gotten any complaints at all about my server's overhead slowing down page load times. Yes, if I were serving some hundred pages per second it might not perform as well, but then I'd also have some sort of high end Xeon processor, not a shitty p2-400.
-=Spork=-