OLE DB Initialization Properties: Quick Reference

0 out of 1 rated this helpful - Rate this topic

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