ADO: ActiveX Data Objects

Name

Connection.Properties Collection — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

Set properties = connection.Properties

The Properties collection contains characteristics specific to the Connection object for the currently used provider.

Datatype

Properties (Collection Object)

Description

The Properties collection class contains a Property class instance for each property specific to the Connection object for the data provider.

The Properties collection of the Connection object contains only the following properties until the Connection is opened:

• Password

• Persist Security Info

• User ID

• Data Source

• Window Handle

• Location

• Mode

• Prompt

• Connect Timeout

• Extended Properties

• Locale Identifier

• Initial Catalog

• OLE DB Services

• General Timeout