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.
Description: Cache Authentication
Description: Encrypt Password
Description: Integrated Security
Description: Mask Password
Description: Password
Description: Persist Encrypted
Description: Persist Security Info
Description: User ID
Description: Asynchronous Processing
OLE DB Documented Value | Connection String Short Value |
DBPROPVAL_ASYNCH_INITIALIZE | Initialize |
Description: Data Source
Description: Window Handle
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 |
Description: Locale Identifier
Description: Location
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 |
Description: Prompt
OLE DB Documented Value | Connection String Short Value |
DBPROMPT_PROMPT | Prompt |
DBPROMPT_COMPLETE | Complete |
DBPROMPT_COMPLETEREQUIRED | CompleteRequired |
DBPROMPT_NOPROMPT | NoPrompt |
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 |
Description: Extended Properties
Description: Connect Timeout
See Also
Referencing a Connection String in Your Application
Appendix C of the OLE DB Programmer's Reference