OLE DB Initialization Properties: Quick Reference

OLE DB Programmer's Reference

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   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

Referencing a Connection String in Your Application | Connection String Syntax | Appendix C: OLE DB Properties

1998-2001 Microsoft Corporation. All rights reserved.