MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 20: OLE DB Core Components


 

OLE DB Initialization Properties: Quick 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_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