Low cost ecommerce web development India flash website design

The Connection Object
Before you can retrieve any data from a database, you have to create and
initialize a connection to that database. In ADO, you use a Connection object
to make and break database connections. A Connection object is a high-level
object that works through a provider (think driver) mat actually makes the
data requests.
Opening a Database Connection
A single project called ActiveX Data Objects Database (ADODB) contains all
the ADO objects. You create a Connection object in the same way as any
other ASP object - with the Server.CreateObject method.
Dim Conn
Set Conn = Server.CreateObject(“ADODB.Connection")
By default, connections are read-only, but you can create a read-write or
write-only connection by setting the Connection object's Mode property.
There are several Mode constants - in fact, ADO is rife with constants. You
have to include the adovbs.inc file (provided in the appendix to this guide).
To use the ADO constants, include the following line in each file where you
use ADO, substituting the appropriate drive and path for your server:

57
<!-- #INCLUDE FILE=”adovbs.inc” -->
ACTIVE SERVER PAGES 3.0
If you open the adovbs.inc file with Notepad or another text editor, you'll
see groups of constants.