This article explains ADO connection strings and parameters. By the end of the article you should be able to build appropriate ones on your own instead of cutting and pasting them.
Version: n/a Platform(s): n/a Updated: Tue May 22 2001
This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names and the name of the table. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code.
Version: n/a Platform(s): n/a Updated: Mon May 21 2001
This article presents three modular routines to access and fetch data easier with ASP. Topics include: Fetching a Recordset, An alternative to the GetConnectedRecordSet function that opens a connection, fetches a recordset, and immediately closes the connection, and Utilities for Creating Valid SQL Statements.
Version: n/a Platform(s): n/a Updated: Wed May 16 2001
A discussion of how to use null values effectively in your database tables. Includes a discussion of the logic behind nulls and some practical programming techniques.
Version: n/a Platform(s): n/a Updated: Tue May 1 2001
This is a sample code that combines a Database Paging and a Database Search script into one. It shows you how to perform a wilcard search on a database table and then page through the results.
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 example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.
This is a step by step tutorial on uploading and inserting binary data (images, files, etc.) into Access Database. Online demo, and sample code available for download.
Version: n/a Platform(s): n/a Updated: Sun Apr 1 2001
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.
Version: n/a Platform(s): n/a Updated: Thu Mar 22 2001
By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. This article explains how to create a Visual Basic ActiveX DLL that controls database functionality.
Version: n/a Platform(s): n/a Updated: Mon Mar 19 2001
Paging is basically querying a database and presenting a page full of the query's results. In ASP and SQL Server programming, there are three approaches to paging. This article compares the approaches and explains which one is the most efficient when dealing with very large sets of data.
Version: n/a Platform(s): n/a Updated: Thu Mar 8 2001
It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions.
Version: n/a Platform(s): n/a Updated: Tue Feb 27 2001
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.
Version: n/a Platform(s): n/a Updated: Tue Feb 20 2001
It is possible to store images in a database using a number of third party tools or a custom built component. Once you have the images stored in your database, however, displaying them requires the use of a simple ASP page. This tutorial explains how to retrieve images from a database table and use them in an HTML page.
Version: n/a Platform(s): n/a Updated: Thu Jan 11 2001
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.
Version: n/a Platform(s): n/a Updated: Mon Jan 8 2001
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.
Version: 1.0 Platform(s): n/a Updated: Sun Jan 7 2001
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.
Version: n/a Platform(s): n/a Updated: Thu Dec 21 2000
