Database-related

SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn't tell you where the error is. This tutorial provides a nice summary of SQL statements.

This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).

ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. This tutorial will show you how to do it two ways: in the global.asa and in any ASP page.

Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes.

Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse these DSNs and thus, with some modifications, use the same DSN for as many database connections.

This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine. After a System DSN has been created you can use it within any ASP page located on the same computer.

Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes an Access database of Mark "The Bird" Fidrych and displays all of his season statistics for 1976 contained in the database rather than displaying the entire db.

The ASP data access component is one of the most powerful features of ASP. With this component you are able to interface your database(s) directly with your webserver. Database access in ASP is, or can be, very complex. This online tutorial focuses on just a few objects to help you get started with the basics and you can then move forward from there.