OLE DB Initialization Properties: Quick Reference

When manually building a connection string, identify keywords by using the property description of the OLE DB initialization property that you want to set. Set keyword values using the short value.

The following table lists the property description for each standard OLE DB initialization property and, where applicable, the OLE DB documented value with its corresponding short value. For information about provider-specific properties, see the documentation that came with your provider.

Initialization property

OLE DB documented value

Short value

DBPROP_AUTH_CACHE_AUTHINFO

Description: Cache Authentication

DBPROP_AUTH_ENCRYPT_PASSWORD

Description: Encrypt Password

DBPROP_AUTH_INTEGRATED

Description: Integrated Security

DBPROP_AUTH_MASK_PASSWORD

Description: Mask Password

DBPROP_AUTH_PASSWORD

Description: Password

DBPROP_AUTH_PERSIST_ENCRYPTED

Description: Persist Encrypted

DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO

Description: Persist Security Info

DBPROP_AUTH_USERID

Description: User ID

DBPROP_INIT_ASYNCH

Description: Asynchronous

Processing

DBPROPVAL_ASYNCH_INITIALIZE

Initialize

DBPROP_INIT_BINDFLAGS

Description: Bind Flags

DB_BINDFLAGS_COLLECTION

DB_BINDFLAGS_DELAYFETCHCOLUMNS

DB_BINDFLAGS_DELAYFETCHSTREAM

DB_BINDFLAGS_ISSTRUCTUREDDOCUMENT

DB_BINDFLAGS_OPENIFEXISTS

DB_BINDFLAGS_OUTPUT

DB_BINDFLAGS_OVERWRITE

DB_BINDFLAGS_RECURSIVE

Collection

DelayFetchColumns

DelayFetchStream

StructuredDocument

OpenIfExists

Output

Overwrite

Recursive

DBPROP_INIT_CATALOG

Description: Initial Catalog

DBPROP_INIT_DATASOURCE

Description: Data Source

DBPROP_INIT_GENERALTIMEOUT

DBPROP_INIT_HWND

Description: Window Handle

DBPROP_INIT_IMPERSONATION_LEVEL

Description: Impersonation Level

DB_IMP_LEVEL_ANONYMOUS

DB_IMP_LEVEL_IDENTIFY

DB_IMP_LEVEL_IMPERSONATE

DB_IMP_LEVEL_DELEGATE

Anonymous

Identify

Impersonate

Delegate

DBPROP_INIT_LCID

Description: Locale Identifier

DBPROP_INIT_LOCATION

Description: Location

DBPROP_INIT_LOCKOWNER

Description: Lock Owner

DBPROP_INIT_MODE

Description: Mode

DB_MODE_READ

DB_MODE_WRITE

DB_MODE_READWRITE

DB_MODE_SHARE_DENY_READ

DB_MODE_SHARE_DENY_WRITE

DB_MODE_SHARE_EXCLUSIVE

DB_MODE_SHARE_DENY_NONE

Read

Write

ReadWrite

Share Deny Read

Share Deny Write

Share Exclusive

Share Deny None

DBPROP_INIT_OLEDBSERVICES

Description: OLE DB Services

DBPROPVAL_OS_RESOURCEPOOLING

DBPROPVAL_OS_TXNENLISTMENT

DBPROPVAL_OS_ENABLEALL

DBPROPVAL_OS_DISABLEALL

DBPROPVAL_OS_CLIENTCURSOR

DBPROPVAL_OS_AGR_AFTERSESSION

ResourcePooling

TxnEnlistment

EnableAll

DisableAll

ClientCursor

AgrAfterSession

DBPROP_INIT_PROMPT

Description: Prompt

DBPROMPT_PROMPT

DBPROMPT_COMPLETE

DBPROMPT_COMPLETEREQUIRED

DBPROMPT_NOPROMPT

Prompt

Complete

CompleteRequired

NoPrompt

DBPROP_INIT_PROTECTION_LEVEL

Description: Protection Level

DB_PROT_LEVEL_NONE

DB_PROT_LEVEL_CONNECT

DB_PROT_LEVEL_CALL

DB_PROT_LEVEL_PKT

DB_PROT_LEVEL_PKT_INTEGRITY

DB_PROT_LEVEL_PKT_PRIVACY

None

Connect

Call

Pkt

Pkt Integrity

Pkt Privacy

DBPROP_INIT_PROVIDERSTRING

Description: Extended Properties

DBPROP_INIT_TIMEOUT

Description: Connect Timeout

Show: