ActiveX Data Objects: Difference between revisions

Revision as of 12:37, 8 July 2013

Revision as of 02:19, 16 July 2013

Line 26:

; 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 providers. 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 whichthis 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=";