Many new ASP developers run into initial problems with getting their ASP pages to work with their local database. Since there are several different ways to access a database using ADO, and many small details that can go wrong along the way, I decided this would make a nice tool to share with other developers. This page was actually developed by a Microsoft support line technician to help analyze user errors
Common Database Problems There are a number of errors that database programming usually leads one to commit. Here are some handy links to solve some of the more common database errors
Creating a Custom 404 Error Page Have you ever noticed that some sites give you a nice looking page when you mistype a URL, as opposed to one of those nasty 404 File Not Found errors
There are a plethora of database error messages you may receive when running a database query. These FAQs examine some of the most common errors and their resolutions. (8 FAQs)
It's easy to find out everything about your ASP environment. This class compresses all the throw-away code we write everyday into one object but it does it with a twist... This object makes heavy use of the Execute method of VBScript. If you aren't familiar with that function, it allows you to execute ASP code as a string. If this doesn't make a lightbulb appear over your head, view the source to this and see how I used it to achieve 0 code reuse!
You just finished your ASP application in time, barely making the dealine! As you upload the final version to the webserver, you receive an email from your supervisor indicating that he's ready for your demo. You confidently stride into his office and give him instructions on accesses the application through the Intranet.
