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.
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.
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.
Connecting To A Database and Retrieving Results in 9 Easy Steps ASP / Database Integration
Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it's hard to separate the database stuff from the rest of the code so I made this example.
How to connect to an Access database with a DSN ASP / Database Integration
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. In this tutorial we will show you how to connect with a DSN to an Access database called 'examples.mdb' and retrieve all the records from the table 'cars'. Everything is commented so you won't have trouble.
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.
Integrating Flash with an Access Database ASP / Flash and ASP
This article explains how to connect a Flash movie to an Access database, and use an ASP page to query the database and hand information over to the Flash movie. We are going to build a very simple Flash address book to demonstrate the technique.