MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 20: OLE DB Core Components
When manually building a connection string, identify keywords 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 |
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_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 |
See Also