Constants

AffectEnum

Name	Value	Description
adAffectAll	3	Operation affects all records in the recordset.
adAffectAllChapters	4	Operation affects all child (chapter) records.
adAffectCurrent	1	Operation affects only the current record.
adAffectGroup	2	Operation affects records that satisfy the current Filter property.

BookmarkEnum

Name	Value	Description
adBookmarkCurrent		Default. Start at the current record.
adBookmarkFirst	1	Start at the first record.
adBookmarkLast	2	Start at the last record.

CEResyncEnum

Name	Value	Description
adResyncAll	15	Only invoke the Resync for each row that has pending changes.
adResyncAutoIncrement	1	Default. Only invoke Resync for all successfully inserted rows, including their AutoIncrement column values.
adResyncConflicts	2	Only invoke Resync for which the last Update or Delete failed due to a concurrency conflict.
adResyncInserts	8	Only invoke Resync for all successfully inserted rows, including their Identity column values.
adResyncNone		Do not invoke Resync .
adResyncUpdates	4	Only invoke Resync for all successfully updated rows.

CommandTypeEnum

Name	Value	Description
adCmdFile	256	Indicates that the provider should evaluate CommandText as a previously persisted file.
adCmdStoredProc	4	Indicates that the provider should evaluate CommandText as a stored procedure.
adCmdTable	2	Indicates that the provider should generate a SQL query to return all rows from the table named in CommandText .
adCmdTableDirect	512	Indicates that the provider should return all rows from the table named in CommandText .
adCmdText	1	Indicates that the provider should evaluate CommandText as textual definition of a command, such as a SQL statement.
adCmdUnknown	8	Indicates that the type of command in CommandText unknown.

CompareEnum

Name	Value	Description
adCompareEqual	1	The bookmarks are equal.
adCompareGreaterThan	2	The first bookmark is after the second.
adCompareLessThan		The first bookmark is before the second.
adCompareNotComparable	4	The bookmarks cannot be compared.
adCompareNotEqual	3	The bookmarks are not equal and not ordered.

ConnectModeEnum

Name	Value	Description
adModeRead	1	Indicates read-only permissions.
adModeReadWrite	3	Indicates read/write permissions.
adModeShareDenyNone	16	Prevents others from opening connection with any permissions.
adModeShareDenyRead	4	Prevents others from opening connection with read permissions.
adModeShareDenyWrite	8	Prevents others from opening connection with write permissions.
adModeShareExclusive	12	Prevents others from opening connection.
adModeUnknown		Default. Indicates that the permissions have not yet been set or cannot be determined.
adModeWrite	2	Indicates write-only permissions.

ConnectOptionEnum

Name	Value	Description
adAsyncConnect	16	Open the connection asynchronously.
adConnectUnspecified	-1	The connection mode is unspecified.

ConnectPromptEnum

Name	Value	Description
adPromptAlways	1	Always prompt for connection information.
adPromptComplete	2	Only prompt if not enough information was supplied.
adPromptCompleteRequired	3	Only prompt if not enough information was supplied, but disable any options not directly applicable to the connection.
adPromptNever	4	Default. Never prompt for connection information.

CursorLocationEnum

Name	Value	Description
adUseClient	3	Use client-side cursors supplied by the local cursor library.
adUseClientBatch	3	Use client-side cursors supplied by the local cursor library.
adUseNone	1	No cursor services are used.
adUseServer	2	Default. Uses data provider driver supplied cursors.

CursorOptionEnum

Name	Value	Description
adAddNew	16778240	You can use the AddNew method to add new records.
adApproxPosition	16384	You can read and set the AbsolutePosition and AbsolutePage properties.
adBookmark	8192	You can use the Bookmark property to access specific records.
adDelete	16779264	You can use the Delete method to delete records.
adFind	524288	You can use the Find method to find records.
adHoldRecords	256	You can retrieve more records or change the next retrieve position without committing all pending changes.
adIndex	8388608	You can use the Index property to name an index. This value is new to ADO 2.1.
adMovePrevious	512	You can use the ModeFirst , MovePrevious , Move and GetRows methods .
adNotify	262144	The recordset supports Notifications.
adResync	131072	You can update the cursor with the data visible in the underlying database with the Resync method.
adSeek	4194304	You can use the Seek method to find a row in a Recordset. This value is new to ADO 2.1.
adUpdate	16809984	You can use the Update method to modify existing records.
adUpdateBatch	65536	You can use the UpdateBatch or CancelBatch methods to transfer changes to the provider in groups.

CursorTypeEnum

Name	Value	Description
adOpenDynamic	2	Opens a dynamic type cursor.
adOpenForwardOnly		Default. Opens a forward-only type cursor
adOpenKeyset	1	Opens a keyset type cursor.
adOpenStatic	3	Opens a static type cursor.
adOpenUnspecified	-1	Indicates an unspecified value for cursor type.

DataTypeEnum

Name	Value	Description
adBigInt	20	An 8-byte signed integer.
adBinary	128	A binary value.
adBoolean	11	A Boolean value.
adBSTR	8	A null- terminated character string.
adChapter	136	A chapter type, indicating a child recordset.
adChar	129	A String value.
adCurrency	6	A currency value. An 8-byte signed integer scaled by 10,000, with 4 digits to the right of the decimal point.
adDate	7	A Date value. A Double where the whole part is the number of days since December 30 1899, and the fractional part is a fraction of the day.
adDBDate	133	A date value (yyyymmdd).
adDBFileTime	137	A database file time.
adDBTime	134	A time value (hhmmss).
adDBTimeStamp	135	A date-time stamp (yyyymmddhhmmss plus a fraction in billionths).
adDecimal	14	An exact numeric value with fixed precision and scale.
adDouble	5	A double-precision floating point value.
adEmpty		No value was specified.
adError	10	A 32-bit error code.
adFileTime	64	A DOS/Win32 file time. The number of 100 nanosecond intervals since Jan 1 1601.
adGUID	72	A globally unique identifier.
adIDispatch	9	A pointer to an IDispatch interface on an OLE object.
adInteger	3	A 4-byte signed integer.
adIUnknown	13	A pointer to an IUnknown interface on an OLE object.
adLongVarBinary	205	A long binary value.
adLongVarChar	201	A long String value.
adLongVarWChar	203	A long null-terminated string value.
adNumeric	131	An exact numeric value with a fixed precision and scale.
adPropVariant	138	A variant that is not equivalent to an Automation variant.
adSingle	4	A single-precision floating point value.
adSmallInt	2	A 2-byte signed integer.
adTinyInt	16	A 1-byte signed integer.
adUnsignedBigInt	21	An 8-byte unsigned integer.
adUnsignedInt	19	A 4-byte unsigned integer.
adUnsignedSmallInt	18	A 2-byte unsigned integer.
adUnsignedTinyInt	17	A 1-byte unsigned integer.
adUserDefined	132	A user -defined variable.
adVarBinary	204	A binary value.
adVarChar	200	A String value.
adVariant	12	An Automation Variant.
adVarNumeric	139	A variable width exact numeric, with a signed scale value.
adVarWChar	202	A null-terminated Unicode character string.
adWChar	130	A null-terminated Unicode character string.

EditModeEnum

Name	Value	Description
adEditAdd	2	Indicates that the AddNew method has been invoked and the current record in the buffer is a new record that hasn't been saved to the database.
adEditDelete	4	Indicates that the Delete method has been invoked.
adEditInProgress	1	Indicates that data in the current record has been modified but not saved.
adEditNone		Indicates that no editing is in progress.

ErrorValueEnum

Name	Value	Description
adErrBoundToCommand	3707	The application cannot change the ActiveConnection property of a Recordset object with a Command object as its source.
adErrDataConversion	3421	The application is using a value of the wrong type for the current application.
adErrFeatureNotAvailable	3251	The operation requested by the application is not supported by the provider.
adErrIllegalOperation	3219	The operation requested by the application is not allowed in this context.
adErrInTransaction	3246	The application cannot explicitly close a Connection object while in the middle of a transaction.
adErrInvalidArgument	3001	The application is using arguments that are the wrong type, are out of the acceptable range, or are in conflict with one another.
adErrInvalidConnection	3709	The application requested an operation on an object with a reference to a closed or invalid Connection object.
adErrInvalidParamInfo	3708	The application has improperly defined a Parameter object.
adErrItemNotFound	3265	ADO could not find the object in the collection.
adErrNoCurrentRecord	3021	Either BOF or EOF is True , or the current record has been deleted. The operation requested by the application requires a current record.
adErrNotExecuting	3715	The operation is not executing.
adErrNotReentrant	3710	The operation is not reentrant.
adErrObjectClosed	3704	The operation requested by the application is not allowed if the object is closed.
adErrObjectInCollection	3367	Can't append. Object already in collection.
adErrObjectNotSet	3420	The object referenced by the application no longer points to a valid object.
adErrObjectOpen	3705	The operation requested by the application is not allowed if the object is open.
adErrOperationCancelled	3712	The operation was cancelled.
adErrProviderNotFound	3706	ADO could not find the specified provider.
adErrStillConnecting	3713	The operation is still connecting.
adErrStillExecuting	3711	The operation is still executing.
adErrUnsafeOperation	3716	The operation is unsafe under these circumstances.

EventReasonEnum

Name	Value	Description
adRsnAddNew	1	A new record is to be added.
adRsnClose	9	The object is being closed.
adRsnDelete	2	The record is being deleted.
adRsnFirstChange	11	The record has been changed for the first time.
adRsnMove	10	A Move has been invoked and the current record pointer is being moved.
adRsnMoveFirst	12	A MoveFirst has been invoked and the current record pointer is being moved.
adRsnMoveLast	15	A MoveLast has been invoked and the current record pointer is being moved.
adRsnMoveNext	13	A MoveNext has been invoked and the current record pointer is being moved.
adRsnMovePrevious	14	A MovePrevious has been invoked and the current record pointer is being moved.
adRsnRequery	7	The recordset was requeried.
adRsnResynch	8	The recordset was resynchronized.
adRsnUndoAddNew	5	The addition of a new record has been cancelled.
adRsnUndoDelete	6	The deletion of a record has been cancelled.
adRsnUndoUpdate	4	The update of a record has been cancelled.
adRsnUpdate	3	The record is being updated.

EventStatusEnum

Name	Value	Description
adStatusCancel	4	Request cancellation of the operation that is about to occur.
adStatusCantDeny	3	A Will event cannot request cancellation of the operation about to occur.
adStatusErrorsOccurred	2	The operation completed unsuccessfully, or a Will event cancelled the operation.
adStatusOK	1	The operation completed successfully.
adStatusUnwantedEvent	5	Events for this operation are no longer required.

ExecuteOptionEnum

Name	Value	Description
adAsyncExecute	16	The operation is executed asynchronously.
adAsyncFetch	32	The records are fetched asynchronously.
adAsyncFetchNonBlocking	64	The records are fetched asynchronously without blocking subsequent operations.
adExecuteNoRecords	128	Indicates CommandText is a command or stored procedure that does not return rows. Always combined with adCmdText or adCmdStoreProc .

FieldAttributeEnum

Name	Value	Description
adFldCacheDeferred	4096	Indicates that the provider caches field values and that subsequent reads are done from the cache.
adFldFixed	16	Indicates that the field contains fixed-length data.
adFldIsNullable	32	Indicates that the field accepts Null values.
adFldKeyColumn	32768	The field is part of a key column.
adFldLong	128	Indicates that the field is a long binary field, and that the AppendChunk and GetChunk methods can be used.
adFldMayBeNull	64	Indicates that you can read Null values from the field.
adFldMayDefer	2	Indicates that the field is deferred, that is, the field values are not retrieved from the data source with the whole record, but only when you access them.
adFldNegativeScale	16384	The field has a negative scale.
adFldRowID	256	Indicates that the field some kind of record ID.
adFldRowVersion	512	Indicates that the field time or date stamp used to track updates.
adFldUnknownUpdatable	8	Indicates that the provider cannot determine if you can write to the field.
adFldUpdatable	4	Indicates that you can write to the field.

FilterGroupEnum

Name	Value	Description
adFilterAffectedRecords	2	Allows you to view only records affected by the last Delete , Resync , UpdateBatch , or CancelBatch method.
adFilterConflictingRecords	5	Allows you to view the records that failed the last batch update attempt.
adFilterFetchedRecords	3	Allows you to view records in the current cache.
adFilterNone		Removes the current filter and restores all records to view.
adFilterPendingRecords	1	Allows you to view only the records that have changed but have not been sent to the server. Only applicable for batch update mode.
adFilterPredicate	4	Allows you to view records that failed the last batch update attempt.

GetRowsOptionEnum

Name	Value	Description
adGetRowsRest	-1	Retrieves the remainder of the rows in the recordset.

IsolationLevelEnum

Name	Value	Description
adXactBrowse	256	Indicates that from one transaction you can view uncommitted changes in other transactions.
adXactChaos	16	Default. Indicates that you cannot overwrite pending changes from more highly isolated transactions.
adXactCursorStability	4096	Default. Indicates that from one transaction you can view changes in other transactions only after they have been committed.
adXactIsolated	1048576	Indicates that transactions are conducted in isolation of other transactions.
adXactReadCommitted	4096	Same as adXactCursorStability .
adXactReadUncommitted	256	Same as adXactBrowse .
adXactRepeatableRead	65536	Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can bring new recordsets.
adXactSerializable	1048576	Same as adXactIsolated .
adXactUnspecified	-1	Indicates that the provider is using a different IsolationLevel than specified, but that the level cannot be identified.

LockTypeEnum

Name	Value	Description
adLockBatchOptimistic	4	Optimistic batch updates.
adLockOptimistic	3	Optimistic locking, record by record. The provider locks records when Update is called.
adLockPessimistic	2	Pessimistic locking, record by record. The provider locks the record immediately upon editing.
adLockReadOnly	1	Default. Read-only, data cannot be modified.
adLockUnspecified	-1	The clone is created with the same lock type as the original.

MarshalOptionsEnum

Name	Value	Description
adMarshalAll		Default. Indicates that all rows are returned to the server.
adMarshalModifiedOnly	1	Indicates that only modified rows are returned to the server.

ObjectStateEnum

Name	Value	Description
adStateClosed		Default. Indicates that the object is closed.
adStateConnecting	2	Indicates that the object is connecting.
adStateExecuting	4	Indicates that the object is executing a command.
adStateFetching	8	Indicates that the rows of the recordset are being fetched.
adStateOpen	1	Indicates that the object is open.

ParameterAttributesEnum

Name	Value	Description
adParamLong	128	Indicates that the parameter accepts long binary data.
adParamNullable	64	Indicates that the parameter accepts Null values.
adParamSigned	16	Default. Indicates that the parameter accepts signed values.

ParameterDirectionEnum

Name	Value	Description
adParamInput	1	Default. Indicates an input parameter.
adParamInputOutput	3	Indicates both an input and output parameter.
adParamOutput	2	Indicates an output parameter.
adParamReturnValue	4	Indicates a return value.
adParamUnknown		Indicates parameter direction is unknown.

PersistFormatEnum

Name	Value	Description
adPersistADTG		Default. Persist data in Advanced Data Table Gram format.
adPersistXML	1	Persist data in XML format.

PositionEnum

Name	Value	Description
adPosBOF	-2	The current record pointer is at BOF .
adPosEOF	-3	The current record pointer is at EOF .
adPosUnknown	-1	The Recordset is empty, the current position is unknown, or the provider does not support the AbsolutePage property.

PropertyAttributesEnum

Name	Value	Description
adPropNotSupported		Indicates that the property is not supported by the provider.
adPropOptional	2	Indicates that the user does not need to specify a value for this property before the data source is initialized .
adPropRead	512	Indicates that the user can read the property.
adPropRequired	1	Indicates that the user must specify a value for this property before the data source is initialized.
adPropWrite	1024	Indicates that the user can set the property.

RecordStatusEnum

Name	Value	Description
adRecCanceled	256	The record was not saved because the operation was cancelled.
adRecCantRelease	1024	The new record was not saved because of existing record locks.
adRecConcurrencyViolation	2048	The record was not saved because optimistic concurrency was in use.
adRecDBDeleted	262144	The record has already been deleted from the data source.
adRecDeleted	4	The record was deleted.
adRecIntegrityViolation	4096	The record was not saved because the user violated integrity constraints.
adRecInvalid	16	The record was not saved because its bookmark is invalid.
adRecMaxChangesExceeded	8192	The record was not saved because there were too many pending changes.

ResyncEnum

Name	Value	Description
adResyncAllValues	2	Default. Data is overwritten and pending updates are cancelled.
adResyncUnderlyingValues	1	Data is not overwritten and pending updates are not cancelled.

SchemaEnum

Name	Value	Description
adSchemaAsserts		Request assert information.
adSchemaCatalogs	1	Request catalog information.
adSchemaCharacterSets	2	Request character set information.
adSchemaCheckConstraints	5	Request check constraint information.
adSchemaCollations	3	Request collation information.
adSchemaColumnPrivileges	13	Request column privilege information.
adSchemaColumns	4	Request column information.
adSchemaColumnsDomainUsage	11	Request column domain usage information.
adSchemaConstraintColumnUsage	6	Request column constraint usage information.
adSchemaConstraintTableUsage	7	Request table constraint usage information.
adSchemaCubes	32	For multi-dimensional data, view the Cubes schema.
adSchemaDBInfoKeywords	30	Request the keywords from the provider.
adSchemaDBInfoLiterals	31	Request the literals from the provider.
adSchemaDimensions	33	For multi-dimensional data, view the Dimensions schema.
adSchemaForeignKeys	27	Request foreign key information.
adSchemaHierarchies	34	For multi-dimensional data, view the Hierarchies schema.
adSchemaIndexes	12	Request index information.
adSchemaKeyColumnUsage	8	Request key column usage information.
adSchemaLevels	35	For multi-dimensional data, view the Levels schema.
adSchemaMeasures	36	For multi-dimensional data, view the Measures schema.
adSchemaMembers	38	For multi-dimensional data, view the Members schema.
adSchemaPrimaryKeys	28	Request primary key information.
adSchemaProcedureColumns	29	Request stored procedure column information.
adSchemaProcedureParameters	26	Request stored procedure parameter information.
adSchemaProcedures	16	Request stored procedure information.
adSchemaProperties	37	For multi-dimensional data, view the Properties schema.
adSchemaProviderSpecific	-1	Request provider specific information.
adSchemaProviderTypes	22	Request provider type information.
adSchemaReferentialContraints	9	Request referential constraint information.
adSchemaSchemata	17	Request schema information.
adSchemaSQLLanguages	18	Request SQL language support information.
adSchemaStatistics	19	Request statistics information.
adSchemaTableConstraints	10	Request table constraint information.
adSchemaTablePrivileges	14	Request table privilege information.
adSchemaTables	20	Request information about the tables.
adSchemaTranslations	21	Request character set translation information.
adSchemaTrustees	39	Request trustee information. This value is new for ADO 2.1.
adSchemaUsagePrivileges	15	Request user privilege information.
adSchemaViewColumnUsage	24	Request column usage in views information.
adSchemaViews	23	Request view information.
adSchemaViewTableUsage	25	Request table usage in views information.

SearchDirection

Name	Value	Description
adSearchBackward	-1	Search backward from the current record.
adSearchForward	1	Search forward from the current record.

SearchDirectionEnum

Name	Value	Description
adSearchBackward	-1	Search backward from the current record.
adSearchForward	1	Search forward from the current record.

SeekEnum

Name	Value	Description
adSeekAfter	8	Seek the record after the match.
adSeekAfterEQ	4	Seek the record equal to the match, or if no match is found, the record after where the match would have been.
adSeekBefore	32	Seek the record before the match.
adSeekBeforeEQ	16	Seek the record equal to the match, or if no match is found, the record before where the match would have been.
adSeekFirstEQ	1	Seek the first record equal to the match.
adSeekLastEQ	2	Seek the last record equal to the match.

StringFormatEnum

Name	Value	Description
adClipString	2	Rows are delimited by user defined values.

XactAttributeEnum

Name	Value	Description
adXactAbortRetaining	262144	The provider will automatically start a new transaction after a RollbackTrans method call.
adXactAsyncPhaseOne	524288	Perform an asynchronous commit.
adXactCommitRetaining	131072	The provider will automatically start a new transaction after a CommitTrans method call.
adXactSyncPhaseOne	1048576	Performs a synchronous commit.