This tutorial contains a better and clean ASP code to create a sample connection string to an Access database. You may use this sample code in your applications.
ADO and ADO.NET Connection Strings ASP / Database Integration
This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. Connection strings are string variables which contain database connection information and then passed to ADO(ActiveX Data Objects) which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format.
Database Connection Strings ASP / Database Integration
Although our ASP database tutorials all use MS Access connection strings, there are many sorts of database software out there for use with ASP. This tutorial will show you how to connect with them.
Use an include file for your database connection ASP / Database Integration
Use an include file for your database connection. Here's the reason why. Before I wised up to this, I was placing the connection on every page. Then there were some configuration changes and none of the pages worked. This meant that every page had to be edited.
What's in an ADO Connection String? ASP / Database Integration
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.
Paging Records using GetRows ASP / Database Integration
This article 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.
How to connect to MS Access Database Using ASP ASP / Database Integration
This tutorial documents code for connecting to a MS Access Database using the DSN-Less appraoch. With DNS-Less approach all you have to do in your code is define the location where your database resides.
Inserting Rows into a Database ASP / Database Integration
This tutorial will show you how to insert a row of data into a database using ASP and an MS Access database. You can do it on one ASP file, but we'll have two files: one processor page (proc.asp), and one form page (form.asp). Then, we'll make the MS Access database that corresponds to the ASP.