Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database connections with some common database software (Oracle, MySQL, MS Access,MS SQL Server).

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready.

This is a comprehensive tutorial on how to incorporate SQL server 7.0/2000 databases into your ASP pages. Topics include: Installation steps, Creating SQL Server 7.0/2000 Databases, Creating SQL Server 7.0/2000 Tables, Creating SQL Server 7.0/2000 Logins, Setting SQL Server 7.0/2000 Permissions, Increasing SQL Server 7.0/2000 Performance with Indexes, and Distributed SQL Server 7.0/2000 Transactions & Queries.

This short tutorial demonstrates how to insert data into a SQL database using SQL statements.

This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download.

This article describes how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. It shows how to create the code in an automated fashion for use in VBScript connecting to MS SQL Server 7.

In this first article of the ASPHoleTools series, you will be shown the basics for data access. Covers how to create the basic include file for database access, and testing that data access was installed properly on your machine.

Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.

This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.

You can use transactions in ASP as a kind of insurance policy for your database activities, making them safer and providing better error recovery. Transactions are most useful when doing multiple actions on multiple tables. The example below shows just how easy it is to use transactions from ASP, inserting a record into a table and doing a "rollback" if there's a problem.