Tag: ado

ADODB.Connection

ADODB.Recordset

ADODB.Command

All of the above

Open the database, interact with the db, close the database

Open a connection, interact with the db, close the connection

Connection object, RecordingSet object

Connection object, Recordset object

Connect object, RecordingSet object

Connect object, Recordset 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

Specifies whether to use a DSN or DSN-less connection

Specifies which type of database is being used

Specifies the type of ODBC driver to use, database format and filename

Opens the initial connection to a database

DNS, DNS-less

DSN, DSN-less

ODBC, ADO

OLEDB, ADO

DSN

DSN-less

Both

DSN

DSN-less

Both

Type of database

Type of driver to use

Location of database

username

All Of The Above

Connection object

Connection string

Both