You said that this same connect string works with other pages, could you try and create a new page, and start with a basic connection and see if it works, then build in the rest of the functionality slowly, and then if it all works, rename it.
I can't imaging that the default.asp page wouldn't work like any other page.
Jay Shepherd