This is an overview of SYSTEM DSN's, DSN-LESS Connections, and any database permissions that may need to be set on the server. Helpful for people just learning ASP as well as people with some experience.

Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures.

This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP.

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.

Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.

This little wizard will help you count records and display the total. Simply fill in the form, and it will generate the code for you.

This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips.

This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. The reader is required to have a fluid understanding of both data shaping and custom Recordsets.

This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.

This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.