Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Standard and Custom OLE DB Properties

Following is an alphabetical list of OLE DB Properties supported by the Visual FoxPro OLE DB Provider and Visual FoxPro custom properties. Refer to the OLE DB Programmers Reference for detailed descriptions of these properties.

Property Description

DBPROP_ABORTPRESERVE

Preserve on Abort

DBPROP_ACCESSORDER

Access Order

DBPROP_ACTIVESESSIONS

Active Sessions

DBPROP_ALTERCOLUMN

Alter Column Support

DBPROP_APPENDONLY

Append-Only Rowset

DBPROP_ASYNCTXNABORT

Asynchable Abort

DBPROP_ASYNCTXNCOMMIT

Asynchable Commit

DBPROP_AUTH_CACHE_AUTHINFO

Cache Authentication

DBPROP_AUTH_ENCRYPT_PASSWORD

Encrypt Password

DBPROP_AUTH_INTEGRATED

Integrated Security

DBPROP_AUTH_MASK_PASSWORD

Mask Password

DBPROP_AUTH_PASSWORD

Password

DBPROP_AUTH_PERSIST_ENCRYPTED

Persist Encrypted

DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO

Persist Security Info

DBPROP_AUTH_USERID

User ID

DBPROP_BLOCKINGSTORAGEOBJECTS

Blocking Storage Objects

DBPROP_BOOKMARKINFO

Bookmark Information

DBPROP_BOOKMARKS

Use Bookmarks

DBPROP_BOOKMARKSKIPPED

Skip Deleted Bookmarks

DBPROP_BOOKMARKTYPE

Bookmark Type

DBPROP_BYREFACCESSORS

Pass By Ref Accessors

DBPROP_CACHEDEFERRED

Cache Deferred Columns

DBPROP_CANFETCHBACKWARDS

Fetch Backwards

DBPROP_CANHOLDROWS

Hold Rows

DBPROP_CANSCROLLBACKWARDS

Scroll Backwards

DBPROP_CATALOGLOCATION

Catalog Location

DBPROP_CATALOGTERM

Catalog Term

DBPROP_CATALOGUSAGE

Catalog Usage

DBPROP_CHANGEINSERTEDROWS

Change Inserted Rows

DBPROP_COL_AUTOINCREMENT

Autoincrement

DBPROP_COL_DEFAULT

Default

DBPROP_COL_DESCRIPTION

Description

DBPROP_COL_FIXEDLENGTH

Fixed Length

DBPROP_COL_NULLABLE

Nullable

DBPROP_COL_PRIMARYKEY

Primary Key

DBPROP_COL_UNIQUE

Unique

DBPROP_COLUMNDEFINITION

Column Definition

DBPROP_COLUMNRESTRICT

Column Privileges

DBPROP_COMMANDTIMEOUT

Command Time Out

DBPROP_COMMITPRESERVE

Preserve on Commit

DBPROP_CONCATNULLBEHAVIOR

NULL Concatenation Behavior

DBPROP_CURRENTCATALOG

Current Catalog

DBPROP_DATASOURCENAME

Data Source Name

DBPROP_DATASOURCEREADONLY

Read-Only Data Source

DBPROP_DBMSNAME

DBMS Name

DBPROP_DBMSVER

DBMS Version

DBPROP_DEFERRED

Defer Column

DBPROP_DELAYSTORAGEOBJECTS

Delay Storage Object Updates

DBPROP_DSOTHREADMODEL

Data Source Object Threading Model

DBPROP_GROUPBY

GROUP BY Support

DBPROP_HETEROGENEOUSTABLES

Heterogeneous Table Support

DBPROP_IAccessor

IAccessor

DBPROP_IColumnsInfo

IColumnsInfo

DBPROP_IColumnsRowset

IColumnsRowset

DBPROP_IConnectionPointContainer

IConnectionPointContainer

DBPROP_IConvertType

IConvertType

DBPROP_IDENTIFIERCASE

Identifier Case Sensitivity

DBPROP_ILockBytes

ILockBytes

DBPROP_IMMOBILEROWS

Immobile Rows

DBPROP_INDEX_AUTOUPDATE

Auto-Update

DBPROP_INDEX_CLUSTERED

Clustered

DBPROP_INDEX_FILLFACTOR

Fill Factor

DBPROP_INDEX_INITIALSIZE

Initial Size

DBPROP_INDEX_NULLCOLLATION

NULL Collation

DBPROP_INDEX_NULLS

NULL Keys

DBPROP_INDEX_PRIMARYKEY

Primary Key

DBPROP_INDEX_SORTBOOKMARKS

Sort Bookmarks

DBPROP_INDEX_TEMPINDEX

Temporary Index

DBPROP_INDEX_TYPE

Index Type

DBPROP_INDEX_UNIQUE

Unique

DBPROP_INIT_CATALOG

Initial Catalog

DBPROP_INIT_DATASOURCE

Data Source

DBPROP_INIT_HWND

Window Handle

DBPROP_INIT_IMPERSONATION_LEVEL

Impersonation Level

DBPROP_INIT_LCID

Locale Identifier

DBPROP_INIT_LOCATION

Location

DBPROP_INIT_MODE

Mode

DBPROP_INIT_PROMPT

Prompt

DBPROP_INIT_PROTECTION_LEVEL

Protection Level

DBPROP_INIT_PROVIDERSTRING

Extended Properties

DBPROP_INIT_TIMEOUT

Connect Timeout

DBPROP_IProvideMoniker

IProvideMoniker

DBPROP_IRowset

IRowset

DBPROP_IRowsetChange

IRowsetChange

DBPROP_IRowsetCurrentIndex

IRowsetCurrentIndex

DBPROP_IRowsetFind

IRowsetFind

DBPROP_IRowsetIdentity

IRowsetIdentity

DBPROP_IRowsetIndex

IRowsetIndex

DBPROP_IRowsetInfo

IRowsetInfo

DBPROP_IRowsetLocate

IRowsetLocate

DBPROP_IRowsetRefresh

IRowsetRefresh

DBPROP_IRowsetResynch

IRowsetResynch

DBPROP_IRowsetScroll

IRowsetScroll

DBPROP_IRowsetUpdate

IRowsetUpdate

DBPROP_ISequentialStream

ISequentialStream

DBPROP_IStorage

IStorage

DBPROP_IStream

IStream

DBPROP_ISupportErrorInfo

ISupportErrorInfo

DBPROP_LITERALBOOKMARKS

Literal Bookmarks

DBPROP_LITERALIDENTITY

Literal Row Identity

DBPROP_LOCKMODE

Lock Mode

DBPROP_LOCKMODES

Lock Modes

DBPROP_MAXINDEXSIZE

Maximum Index Size

DBPROP_MAXOPENROWS

Maximum Open Rows

DBPROP_MAXPENDINGROWS

Maximum Pending Rows

DBPROP_MAXROWS

Maximum Rows

DBPROP_MAXROWSIZE

Maximum Row Size

DBPROP_MAXROWSIZEINCLUDESBLOB

Maximum Row Size Includes BLOB

DBPROP_MAXTABLESINSELECT

Maximum Tables in SELECT

DBPROP_MAYWRITECOLUMN

Column Writable

DBPROP_MEMORYUSAGE

Memory Usage

DBPROP_MULTIPLEPARAMSETS

Multiple Parameter Sets

DBPROP_MULTIPLERESULTS

Multiple Results

DBPROP_MULTIPLESTORAGEOBJECTS

Multiple Storage Objects

DBPROP_MULTITABLEUPDATE

Multi-Table Update

DBPROP_NOTIFICATIONGRANULARITY

Notification Granularity

DBPROP_NOTIFICATIONPHASES

Notification Phases

DBPROP_NOTIFYCOLUMNSET

Column Set Notification

DBPROP_NOTIFYROWDELETE

Row Delete Notification

DBPROP_NOTIFYROWFIRSTCHANGE

Row First Change Notification

DBPROP_NOTIFYROWINSERT

Row Insert Notification

DBPROP_NOTIFYROWRESYNCH

Row Resynchronization Notification

DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE

Rowset Fetch Position Change Notification

DBPROP_NOTIFYROWSETRELEASE

Rowset Release Notification

DBPROP_NOTIFYROWUNDOCHANGE

Row Undo Change Notification

DBPROP_NOTIFYROWUNDODELETE

Row Undo Delete Notification

DBPROP_NOTIFYROWUNDOINSERT

Row Undo Insert Notification

DBPROP_NOTIFYROWUPDATE

Row Update Notification

DBPROP_NULLCOLLATION

NULL Collation Order

DBPROP_OLEOBJECTS

OLE Object Support

DBPROP_OPENROWSETSUPPORT

Open Rowset Support

DBPROP_ORDERBYCOLUMNSINSELECT

ORDER BY Columns in Select List

DBPROP_ORDEREDBOOKMARKS

Bookmarks Ordered

DBPROP_OTHERINSERT

Others' Inserts Visible

DBPROP_OTHERUPDATEDELETE

Others' Changes Visible

DBPROP_OUTPUTPARAMETERAVAILABILITY

Output Parameter Availability

DBPROP_OWNINSERT

Own Inserts Visible

DBPROP_OWNUPDATEDELETE

Own Changes Visible

DBPROP_PERSISTENTIDTYPE

Persistent ID Type

DBPROP_PREPAREABORTBEHAVIOR

Prepare Abort Behavior

DBPROP_PREPARECOMMITBEHAVIOR

Prepare Commit Behavior

DBPROP_PROCEDURETERM

Procedure Term

DBPROP_PROVIDERFRIENDLYNAME

Provider Friendly Name

DBPROP_PROVIDERNAME

Provider Name

DBPROP_PROVIDEROLEDBVER

OLE DB Version

DBPROP_PROVIDERVER

Provider Version

DBPROP_QUICKRESTART

Quick Restart

DBPROP_QUOTEDIDENTIFIERCASE

Quoted Identifier Sensitivity

DBPROP_REENTRANTEVENTS

Reentrant Events

DBPROP_REMOVEDELETED

Remove Deleted Rows

DBPROP_REPORTMULTIPLECHANGES

Report Multiple Changes

DBPROP_RETURNPENDINGINSERTS

Return Pending Inserts

DBPROP_ROWRESTRICT

Row Privileges

DBPROP_ROWSETCONVERSIONSONCOMMAND

Rowset Conversions on Command

DBPROP_ROWTHREADMODEL

Row Threading Model

DBPROP_SCHEMATERM

Schema Term

DBPROP_SCHEMAUSAGE

Schema Usage

DBPROP_SERVERCURSOR

Server Cursor

DBPROP_SERVERDATAONINSERT

Server Data on Insert

DBPROP_SERVERNAME

Server Name

DBPROP_SESS_AUTOCOMMITISOLEVELS

Autocommit Isolation Levels

DBPROP_SQLSUPPORT

SQL Support

DBPROP_STRONGIDENTITY

Strong Row Identity

DBPROP_STRUCTUREDSTORAGE

Structured Storage

DBPROP_SUBQUERIES

Subquery Support

DBPROP_SUPPORTEDTXNDDL

Transaction DDL

DBPROP_SUPPORTEDTXNISOLEVELS

Isolation Levels

DBPROP_SUPPORTEDTXNISORETAIN

Isolation Retention

DBPROP_TABLETERM

Table Term

DBPROP_TBL_TEMPTABLE

Temporary Table

DBPROP_TRANSACTEDOBJECT

Objects Transacted

DBPROP_UPDATABILITY

Updatability

DBPROP_USERNAME

User Name

DBPROP_VFPOLEDB_ANSI

SET ANSI

DBPROP_VFPOLEDB_BLOCKSIZE

SET BLOCKSIZE

DBPROP_VFPOLEDB_COLLATE

SET COLLATE setting

DBPROP_VFPOLEDB_Column_Caption

Column Caption

DBPROP_VFPOLEDB_Column_Comment

Column Comment

DBPROP_VFPOLEDB_Column_Default

Default Value

DBPROP_VFPOLEDB_Column_Error

 

DBPROP_VFPOLEDB_Column_Format

Format

DBPROP_VFPOLEDB_Column_FormDisplay

DisplayClass

DBPROP_VFPOLEDB_Column_FormPath

DisplayClassLibrary

DBPROP_VFPOLEDB_Column_InputMask

InputMask

DBPROP_VFPOLEDB_Column_RuleExpression

RuleExpression

DBPROP_VFPOLEDB_Column_RuleText

RuleText

DBPROP_VFPOLEDB_DELETED

SET DELETED

DBPROP_VFPOLEDB_EXACT

SET EXACT

DBPROP_VFPOLEDB_INDEX

SET INDEX

DBPROP_VFPOLEDB_INIT_COLLATE

Collating Sequence

DBPROP_VFPOLEDB_NULL

SET NULL

DBPROP_VFPOLEDB_ORDER

SET ORDER

DBPROP_VFPOLEDB_PATH

SET PATH

DBPROP_VFPOLEDB_REPROCESS

SET REPROCESS

DBPROP_VFPOLEDB_Rowset_SP

Stored Procedure

DBPROP_VFPOLEDB_SESS_ID

Internal Session ID

DBPROP_VFPOLEDB_SETDEBUGOUTTO

Debug Output File

DBPROP_VFPOLEDB_SETDEFAULTTO

Default Drive and Folder

DBPROP_VFPOLEDB_SETFULLPATH

Set Fullpath ON/OFF

DBPROP_VFPOLEDB_Table_Comment

Comment

DBPROP_VFPOLEDB_Table_DeleteTrigger

DeleteTrigger

DBPROP_VFPOLEDB_Table_InsertTrigger

InsertTrigger

DBPROP_VFPOLEDB_Table_Path

Path

DBPROP_VFPOLEDB_Table_PrimaryKey

PrimaryKey

DBPROP_VFPOLEDB_Table_RuleExpression

RuleExpression

DBPROP_VFPOLEDB_Table_RuleText

RuleText

DBPROP_VFPOLEDB_Table_UpdateTrigger

UpdateTrigger

DBPROP_VFPOLEDB_UNIQUE

SET UNIQUE

Community Additions

ADD
Show:
© 2015 Microsoft