Database connectivity with ADO has 3 main objects:
ADODB.Connection
ADODB.Recordset
ADODB.Command
All of the above
What is the sequential procedure in working with databases?
Open the database, interact with the db, close the database
Open a connection, interact with the db, close the connection
ActiveX Data Objects (ADO) comes installed with ASP and allows your pages to easily connect to databases. Which two ADO objects are used to open a connection and interact with the database?
Connection object, RecordingSet object
Connection object, Recordset object
Connect object, RecordingSet object
Connect object, Recordset object
What is a connection object?
Specifies whether to use a DSN or DSN-less connection
Specifies which type of database is being used
Specifies the type of driver to use, database format and filename
First opens the initial connection to a database before giving any database information
What is a connection string?
Specifies the type of ODBC driver to use, database format and filename
Opens the initial connection to a database
There are two methods of connecting to an Access database. Which are they?
DNS, DNS-less
DSN, DSN-less
ODBC, ADO
OLEDB, ADO
Which connection method requires a connection object?
DSN
DSN-less
Both
Which connection method requires a connection string?
What information can a connection string contain about the database you are trying to connect to?
Type of database
Type of driver to use
Location of database
username
All Of The Above
What must your ASP code have if you are using the DSN method of connecting?
Connection object
Connection string