Export (0) Print
Expand All

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:
© 2014 Microsoft