OLE DB Initialization Properties: Quick Reference

When manually building a connection string, identify keywords using the Description property of the OLE DB initialization property that you want to set. Set keyword values using the "short" value.

This document lists the Description property and the short value (where applicable) for each standard OLE DB initialization property. For information about provider-specific properties, see the documentation that came with your provider.

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

OLE DB Documented Value Connection String Short Value
DBPROPVAL_ASYNCH_INITIALIZE Initialize

DBPROP_INIT_DATASOURCE

Description: Data Source

DBPROP_INIT_HWND

Description: Window Handle

DBPROP_INIT_IMPERSONATION_LEVEL

Description: Impersonation Level

OLE DB Documented Value Connection String Short Value
DB_IMP_LEVEL_ANONYMOUS Anonymous
DB_IMP_LEVEL_IDENTIFY Identify
DB_IMP_LEVEL_IMPERSONATE Impersonate
DB_IMP_LEVEL_DELEGATE Delegate

DBPROP_INIT_LCID

Description: Locale Identifier

DBPROP_INIT_LOCATION

Description: Location

DBPROP_INIT_MODE

Description: Mode

OLE DB Documented Value Connection String Short Value
DB_MODE_READ Read
DB_MODE_WRITE Write
DB_MODE_READWRITE ReadWrite
DB_MODE_SHARE_DENY_READShare Share Deny Read
DB_MODE_SHARE_DENY_WRITE Share Deny Write
DB_MODE_SHARE_EXCLUSIVE Share Exclusive
DB_MODE_SHARE_DENY_NONE Share Deny None

DBPROP_INIT_PROMPT

Description: Prompt

OLE DB Documented Value Connection String Short Value
DBPROMPT_PROMPT Prompt
DBPROMPT_COMPLETE Complete
DBPROMPT_COMPLETEREQUIRED CompleteRequired
DBPROMPT_NOPROMPT NoPrompt

DBPROP_INIT_PROTECTION_LEVEL

Description: Protection Level

OLE DB Documented Value Connection String Short Value
DB_PROT_LEVEL_NONE None
DB_PROT_LEVEL_CONNECT Connect
DB_PROT_LEVEL_CALL Call
DB_PROT_LEVEL_PKT Pkt
DB_PROT_LEVEL_PKT_INTEGRITY Pkt Integrity
DB_PROT_LEVEL_PKT_PRIVACY 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 of the OLE DB Programmer's Reference