This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.

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 describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.

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.

You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!

This writing will discuss several things to do to ensure the application migration carried on in a good way, particularly for ASP Database applications and to overcome possible problems might occurred. Basically, migrating ASP to Linux means you have to convert to database supported by Linux platforms. Currently, Chili!Soft ASP is already supporting MS Access but not all web hosting companies install this feature. They prefer to use more common database in Linux such as MySQL and PostgreSQL. Pay attention to some Chili!Soft specific ADO methods and properties, since there are slight differences with IIS ASP. You might need to convert some codes in your applications to make it run in Chili!Soft ASP.

This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks.

Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download.

Ever wondered how to create a table, view or procedure with MS Access? This article shows us how to create all three and work with them from an ASP script.

Here is a quick sample of searching a DB for certain records. It's really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect * to work. Why is it %? I have no idea, but it is. An Access 97 version of the database is available for download.