How do I connect to and display records from a database?

The most common way to connect to a database is to use ActiveX Data Objects, which comes as part of the Windows MDAC or Microsoft Data Access Components install (see How do I install ASP on my Win 95/98 machine? for details).