ActiveX Data Objects: Difference between revisions

Revision as of 05:22, 13 November 2014

Revision as of 17:26, 19 April 2015

Line 24:

; Connection

: The connection object is ADO's connection to a data store via OLE DB. The connection object stores information about the session and provides methods of connecting to the data store. As some data stores have different methods of establishing a connection, some methods may not be supported in the connection object for particular OLE DB providersprovider. A connection object connects to the data store using its 'Open' method with a connection string which specifies the connection as a list of key value pairs (for example: "Provider='SQLOLEDB';Data Source='TheSqlServer'; Initial Catalog='Northwind';Integrated Security='SSPI';"). The start of this connection string must identify the type of data store connection that the connection object requires:

:* an OLE DB provider (for example SQLOLEDB), using the syntax "provider=";

:* a file name, using the syntax "file name=";