ServiceComponents

Description

Specifies the global services the OLE DB interface can use.

When to specify ServiceComponents

You must specify the ServiceComponents parameter before connecting to the database.

Applies to

OLE DB

Syntax

ServiceComponents='servicecomponent_name'

Default value

None

Examples

To enable the resource pooling service component:

  • Database profile

    Select Resource Pooling from the Service Component Support box on the System page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="ServiceComponents='DBPROPVAL_OS_RESOURCEPOOLING'"