Extended Properties Property

ADO and SQL Server

ADO and SQL Server

Extended Properties Property

The Extended Properties property sets or retrieves provider-specific connection information that cannot be explicitly described through the property mechanism.

Applies To
Connection Object
Syntax

object.Properties("Extended Properties") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

String containing provider-specific, extended connection information.

Data Type

adBSTR

Modifiable

Read/write

OLE DB Property

DBPROP_INIT_PROVIDERSTRING

Remarks

Use of this property implies that the application developer knows how this string will be interpreted and used by the provider. Applications should use this property only for provider-specific connection information that cannot be explicitly described through the property mechanism.