Page 267 - Open Soource Technologies 304.indd

Unit 12: ADO Data Control

2. Additional ADO Data Control Properties That Affect the Recordset You
will eventually need to fine-tune the Recordset’s behavior by setting
the CursorLocation, CursorType, and Locktype properties. These
properties correspond to the standalone Recordset object’s properties of
the same name. The next chapter discusses these properties and their
meaning in more detail.

12.2 ConnectionString Properties

Use the ConnectionString property to specify a data source by passing a detailed connection
string containing a series of argument = value statements separated by semicolons.
ADO supports five arguments for the ConnectionString property; any other arguments pass directly
to the provider without any processing by ADO. The arguments ADO supports are as follows:

Argument Description

Providers= Specifies the name of a provider to use for the connection.
File Name= Specifies the name of a provider-specific file (for example a persisted
data source object) containing preset connection information.
Remote Provider= Specifies the name of a provider to use when opening a client-side
connection (Remote Data Service only)
Remote Service= Specifies the path name of the server to use when opening a client-side
connection (Remote Data Service only)
URL= Specific the connection string as an absolute URL identifying a resource
such as a file or directory.

After you set the ConnectionString property and open the Connection object, the provider may
alter the contents of the property, for example, by mapping the ADO-defined argument names
to their equivalents for the specific provider.
Table 12.4: Lists the Default ADO Provider for Each Windows Operating System

The ConnectionString property automatically inherits the value used for the ConnectionString
argument of the Open method, so you can override the current ConnectionString property during
the Open method call.

LOVELY PROFESSIONAL UNIVERSITY 261