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

See Also

Reference

Referencing a Connection String in Your Application

Connection String Syntax

Appendix C: OLE DB Properties