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 |