Share via


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

See Also

Language Reference for OLE DB Development | Visual FoxPro OLE DB Provider Data Support | Supported Visual FoxPro SET Commands | Supported Visual FoxPro Commands and Functions | Unsupported Visual FoxPro Commands and Functions | Supported OLE DB Objects | OLE DB Provider for Visual FoxPro