DefinitelyTyped/types/activex-adodb/index.d.ts

// Type definitions for non-npm package Microsoft ActiveX Data Objects 6.0 Library - ADODB 6.1
// Project: https://msdn.microsoft.com/en-us/library/jj249010.aspx
// Definitions by: Zev Spitz <https://github.com/zspitz>
// Definitions: https://github.com/DefinitelyTyped/DefinitelyTyped
// TypeScript Version: 2.6

/// <reference types="activex-interop" />

declare namespace ADODB {
    const enum ADCPROP_ASYNCTHREADPRIORITY_ENUM {
        adPriorityAboveNormal = 4,
        adPriorityBelowNormal = 2,
        adPriorityHighest = 5,
        adPriorityLowest = 1,
        adPriorityNormal = 3,
    }

    const enum ADCPROP_AUTORECALC_ENUM {
        adRecalcAlways = 1,
        adRecalcUpFront = 0,
    }

    const enum ADCPROP_UPDATECRITERIA_ENUM {
        adCriteriaAllCols = 1,
        adCriteriaKey = 0,
        adCriteriaTimeStamp = 3,
        adCriteriaUpdCols = 2,
    }

    const enum ADCPROP_UPDATERESYNC_ENUM {
        adResyncAll = 15,
        adResyncAutoIncrement = 1,
        adResyncConflicts = 2,
        adResyncInserts = 8,
        adResyncNone = 0,
        adResyncUpdates = 4,
    }

    const enum AffectEnum {
        adAffectAll = 3,
        adAffectAllChapters = 4,
        adAffectCurrent = 1,
        adAffectGroup = 2,
    }

    const enum BookmarkEnum {
        adBookmarkCurrent = 0,
        adBookmarkFirst = 1,
        adBookmarkLast = 2,
    }

    const enum CommandTypeEnum {
        adCmdFile = 256,
        adCmdStoredProc = 4,
        adCmdTable = 2,
        adCmdTableDirect = 512,
        adCmdText = 1,
        adCmdUnknown = 8,
        adCmdUnspecified = -1,
    }

    const enum CompareEnum {
        adCompareEqual = 1,
        adCompareGreaterThan = 2,
        adCompareLessThan = 0,
        adCompareNotComparable = 4,
        adCompareNotEqual = 3,
    }

    const enum ConnectModeEnum {
        adModeRead = 1,
        adModeReadWrite = 3,
        adModeRecursive = 4194304,
        adModeShareDenyNone = 16,
        adModeShareDenyRead = 4,
        adModeShareDenyWrite = 8,
        adModeShareExclusive = 12,
        adModeUnknown = 0,
        adModeWrite = 2,
    }

    const enum ConnectOptionEnum {
        adAsyncConnect = 16,
        adConnectUnspecified = -1,
    }

    const enum ConnectPromptEnum {
        adPromptAlways = 1,
        adPromptComplete = 2,
        adPromptCompleteRequired = 3,
        adPromptNever = 4,
    }

    const enum CopyRecordOptionsEnum {
        adCopyAllowEmulation = 4,
        adCopyNonRecursive = 2,
        adCopyOverWrite = 1,
        adCopyUnspecified = -1,
    }

    const enum CursorLocationEnum {
        adUseClient = 3,
        adUseClientBatch = 3,
        adUseNone = 1,
        adUseServer = 2,
    }

    const enum CursorOptionEnum {
        adAddNew = 16778240,
        adApproxPosition = 16384,
        adBookmark = 8192,
        adDelete = 16779264,
        adFind = 524288,
        adHoldRecords = 256,
        adIndex = 8388608,
        adMovePrevious = 512,
        adNotify = 262144,
        adResync = 131072,
        adSeek = 4194304,
        adUpdate = 16809984,
        adUpdateBatch = 65536,
    }

    const enum CursorTypeEnum {
        adOpenDynamic = 2,
        adOpenForwardOnly = 0,
        adOpenKeyset = 1,
        adOpenStatic = 3,
        adOpenUnspecified = -1,
    }

    const enum DataTypeEnum {
        adArray = 8192,
        adBigInt = 20,
        adBinary = 128,
        adBoolean = 11,
        adBSTR = 8,
        adChapter = 136,
        adChar = 129,
        adCurrency = 6,
        adDate = 7,
        adDBDate = 133,
        adDBTime = 134,
        adDBTimeStamp = 135,
        adDecimal = 14,
        adDouble = 5,
        adEmpty = 0,
        adError = 10,
        adFileTime = 64,
        adGUID = 72,
        adIDispatch = 9,
        adInteger = 3,
        adIUnknown = 13,
        adLongVarBinary = 205,
        adLongVarChar = 201,
        adLongVarWChar = 203,
        adNumeric = 131,
        adPropVariant = 138,
        adSingle = 4,
        adSmallInt = 2,
        adTinyInt = 16,
        adUnsignedBigInt = 21,
        adUnsignedInt = 19,
        adUnsignedSmallInt = 18,
        adUnsignedTinyInt = 17,
        adUserDefined = 132,
        adVarBinary = 204,
        adVarChar = 200,
        adVariant = 12,
        adVarNumeric = 139,
        adVarWChar = 202,
        adWChar = 130,
    }

    const enum EditModeEnum {
        adEditAdd = 2,
        adEditDelete = 4,
        adEditInProgress = 1,
        adEditNone = 0,
    }

    const enum ErrorValueEnum {
        adErrBoundToCommand = 3707,
        adErrCannotComplete = 3732,
        adErrCantChangeConnection = 3748,
        adErrCantChangeProvider = 3220,
        adErrCantConvertvalue = 3724,
        adErrCantCreate = 3725,
        adErrCatalogNotSet = 3747,
        adErrColumnNotOnThisRow = 3726,
        adErrConnectionStringTooLong = 3754,
        adErrDataConversion = 3421,
        adErrDataOverflow = 3721,
        adErrDelResOutOfScope = 3738,
        adErrDenyNotSupported = 3750,
        adErrDenyTypeNotSupported = 3751,
        adErrFeatureNotAvailable = 3251,
        adErrFieldsUpdateFailed = 3749,
        adErrIllegalOperation = 3219,
        adErrIntegrityViolation = 3719,
        adErrInTransaction = 3246,
        adErrInvalidArgument = 3001,
        adErrInvalidConnection = 3709,
        adErrInvalidParamInfo = 3708,
        adErrInvalidTransaction = 3714,
        adErrInvalidURL = 3729,
        adErrItemNotFound = 3265,
        adErrNoCurrentRecord = 3021,
        adErrNotExecuting = 3715,
        adErrNotReentrant = 3710,
        adErrObjectClosed = 3704,
        adErrObjectInCollection = 3367,
        adErrObjectNotSet = 3420,
        adErrObjectOpen = 3705,
        adErrOpeningFile = 3002,
        adErrOperationCancelled = 3712,
        adErrOutOfSpace = 3734,
        adErrPermissionDenied = 3720,
        adErrPropConflicting = 3742,
        adErrPropInvalidColumn = 3739,
        adErrPropInvalidOption = 3740,
        adErrPropInvalidValue = 3741,
        adErrPropNotAllSettable = 3743,
        adErrPropNotSet = 3744,
        adErrPropNotSettable = 3745,
        adErrPropNotSupported = 3746,
        adErrProviderFailed = 3000,
        adErrProviderNotFound = 3706,
        adErrProviderNotSpecified = 3753,
        adErrReadFile = 3003,
        adErrResourceExists = 3731,
        adErrResourceLocked = 3730,
        adErrResourceOutOfScope = 3735,
        adErrSchemaViolation = 3722,
        adErrSignMismatch = 3723,
        adErrStillConnecting = 3713,
        adErrStillExecuting = 3711,
        adErrTreePermissionDenied = 3728,
        adErrUnavailable = 3736,
        adErrUnsafeOperation = 3716,
        adErrURLDoesNotExist = 3727,
        adErrURLNamedRowDoesNotExist = 3737,
        adErrVolumeNotFound = 3733,
        adErrWriteFile = 3004,
        adwrnSecurityDialog = 3717,
        adwrnSecurityDialogHeader = 3718,
    }

    const enum EventReasonEnum {
        adRsnAddNew = 1,
        adRsnClose = 9,
        adRsnDelete = 2,
        adRsnFirstChange = 11,
        adRsnMove = 10,
        adRsnMoveFirst = 12,
        adRsnMoveLast = 15,
        adRsnMoveNext = 13,
        adRsnMovePrevious = 14,
        adRsnRequery = 7,
        adRsnResynch = 8,
        adRsnUndoAddNew = 5,
        adRsnUndoDelete = 6,
        adRsnUndoUpdate = 4,
        adRsnUpdate = 3,
    }

    const enum EventStatusEnum {
        adStatusCancel = 4,
        adStatusCantDeny = 3,
        adStatusErrorsOccurred = 2,
        adStatusOK = 1,
        adStatusUnwantedEvent = 5,
    }

    const enum ExecuteOptionEnum {
        adAsyncExecute = 16,
        adAsyncFetch = 32,
        adAsyncFetchNonBlocking = 64,
        adExecuteNoRecords = 128,
        adExecuteRecord = 2048,
        adExecuteStream = 1024,
        adOptionUnspecified = -1,
    }

    const enum FieldAttributeEnum {
        adFldCacheDeferred = 4096,
        adFldFixed = 16,
        adFldIsChapter = 8192,
        adFldIsCollection = 262144,
        adFldIsDefaultStream = 131072,
        adFldIsNullable = 32,
        adFldIsRowURL = 65536,
        adFldKeyColumn = 32768,
        adFldLong = 128,
        adFldMayBeNull = 64,
        adFldMayDefer = 2,
        adFldNegativeScale = 16384,
        adFldRowID = 256,
        adFldRowVersion = 512,
        adFldUnknownUpdatable = 8,
        adFldUnspecified = -1,
        adFldUpdatable = 4,
    }

    const enum FieldEnum {
        adDefaultStream = -1,
        adRecordURL = -2,
    }

    const enum FieldStatusEnum {
        adFieldAlreadyExists = 26,
        adFieldBadStatus = 12,
        adFieldCannotComplete = 20,
        adFieldCannotDeleteSource = 23,
        adFieldCantConvertValue = 2,
        adFieldCantCreate = 7,
        adFieldDataOverflow = 6,
        adFieldDefault = 13,
        adFieldDoesNotExist = 16,
        adFieldIgnore = 15,
        adFieldIntegrityViolation = 10,
        adFieldInvalidURL = 17,
        adFieldIsNull = 3,
        adFieldOK = 0,
        adFieldOutOfSpace = 22,
        adFieldPendingChange = 262144,
        adFieldPendingDelete = 131072,
        adFieldPendingInsert = 65536,
        adFieldPendingUnknown = 524288,
        adFieldPendingUnknownDelete = 1048576,
        adFieldPermissionDenied = 9,
        adFieldReadOnly = 24,
        adFieldResourceExists = 19,
        adFieldResourceLocked = 18,
        adFieldResourceOutOfScope = 25,
        adFieldSchemaViolation = 11,
        adFieldSignMismatch = 5,
        adFieldTruncated = 4,
        adFieldUnavailable = 8,
        adFieldVolumeNotFound = 21,
    }

    const enum FilterGroupEnum {
        adFilterAffectedRecords = 2,
        adFilterConflictingRecords = 5,
        adFilterFetchedRecords = 3,
        adFilterNone = 0,
        adFilterPendingRecords = 1,
        adFilterPredicate = 4,
    }

    const enum GetRowsOptionEnum {
        adGetRowsRest = -1,
    }

    const enum IsolationLevelEnum {
        adXactBrowse = 256,
        adXactChaos = 16,
        adXactCursorStability = 4096,
        adXactIsolated = 1048576,
        adXactReadCommitted = 4096,
        adXactReadUncommitted = 256,
        adXactRepeatableRead = 65536,
        adXactSerializable = 1048576,
        adXactUnspecified = -1,
    }

    const enum LineSeparatorEnum {
        adCR = 13,
        adCRLF = -1,
        adLF = 10,
    }

    const enum LockTypeEnum {
        adLockBatchOptimistic = 4,
        adLockOptimistic = 3,
        adLockPessimistic = 2,
        adLockReadOnly = 1,
        adLockUnspecified = -1,
    }

    const enum MarshalOptionsEnum {
        adMarshalAll = 0,
        adMarshalModifiedOnly = 1,
    }

    const enum MoveRecordOptionsEnum {
        adMoveAllowEmulation = 4,
        adMoveDontUpdateLinks = 2,
        adMoveOverWrite = 1,
        adMoveUnspecified = -1,
    }

    const enum ObjectStateEnum {
        adStateClosed = 0,
        adStateConnecting = 2,
        adStateExecuting = 4,
        adStateFetching = 8,
        adStateOpen = 1,
    }

    const enum ParameterAttributesEnum {
        adParamLong = 128,
        adParamNullable = 64,
        adParamSigned = 16,
    }

    const enum ParameterDirectionEnum {
        adParamInput = 1,
        adParamInputOutput = 3,
        adParamOutput = 2,
        adParamReturnValue = 4,
        adParamUnknown = 0,
    }

    const enum PersistFormatEnum {
        adPersistADTG = 0,
        adPersistXML = 1,
    }

    const enum PositionEnum {
        adPosBOF = -2,
        adPosEOF = -3,
        adPosUnknown = -1,
    }

    const enum PositionEnum_Param {
        adPosBOF = -2,
        adPosEOF = -3,
        adPosUnknown = -1,
    }

    const enum PropertyAttributesEnum {
        adPropNotSupported = 0,
        adPropOptional = 2,
        adPropRead = 512,
        adPropRequired = 1,
        adPropWrite = 1024,
    }

    const enum RecordCreateOptionsEnum {
        adCreateCollection = 8192,
        adCreateNonCollection = 0,
        adCreateOverwrite = 67108864,
        adCreateStructDoc = -2147483648,
        adFailIfNotExists = -1,
        adOpenIfExists = 33554432,
    }

    const enum RecordOpenOptionsEnum {
        adDelayFetchFields = 32768,
        adDelayFetchStream = 16384,
        adOpenAsync = 4096,
        adOpenExecuteCommand = 65536,
        adOpenOutput = 8388608,
        adOpenRecordUnspecified = -1,
        adOpenSource = 8388608,
    }

    const enum RecordStatusEnum {
        adRecCanceled = 256,
        adRecCantRelease = 1024,
        adRecConcurrencyViolation = 2048,
        adRecDBDeleted = 262144,
        adRecDeleted = 4,
        adRecIntegrityViolation = 4096,
        adRecInvalid = 16,
        adRecMaxChangesExceeded = 8192,
        adRecModified = 2,
        adRecMultipleChanges = 64,
        adRecNew = 1,
        adRecObjectOpen = 16384,
        adRecOK = 0,
        adRecOutOfMemory = 32768,
        adRecPendingChanges = 128,
        adRecPermissionDenied = 65536,
        adRecSchemaViolation = 131072,
        adRecUnmodified = 8,
    }

    const enum RecordTypeEnum {
        adCollectionRecord = 1,
        adSimpleRecord = 0,
        adStructDoc = 2,
    }

    const enum ResyncEnum {
        adResyncAllValues = 2,
        adResyncUnderlyingValues = 1,
    }

    const enum SaveOptionsEnum {
        adSaveCreateNotExist = 1,
        adSaveCreateOverWrite = 2,
    }

    const enum SchemaEnum {
        adSchemaActions = 41,
        adSchemaAsserts = 0,
        adSchemaCatalogs = 1,
        adSchemaCharacterSets = 2,
        adSchemaCheckConstraints = 5,
        adSchemaCollations = 3,
        adSchemaColumnPrivileges = 13,
        adSchemaColumns = 4,
        adSchemaColumnsDomainUsage = 11,
        adSchemaCommands = 42,
        adSchemaConstraintColumnUsage = 6,
        adSchemaConstraintTableUsage = 7,
        adSchemaCubes = 32,
        adSchemaDBInfoKeywords = 30,
        adSchemaDBInfoLiterals = 31,
        adSchemaDimensions = 33,
        adSchemaForeignKeys = 27,
        adSchemaFunctions = 40,
        adSchemaHierarchies = 34,
        adSchemaIndexes = 12,
        adSchemaKeyColumnUsage = 8,
        adSchemaLevels = 35,
        adSchemaMeasures = 36,
        adSchemaMembers = 38,
        adSchemaPrimaryKeys = 28,
        adSchemaProcedureColumns = 29,
        adSchemaProcedureParameters = 26,
        adSchemaProcedures = 16,
        adSchemaProperties = 37,
        adSchemaProviderSpecific = -1,
        adSchemaProviderTypes = 22,
        adSchemaReferentialConstraints = 9,
        adSchemaReferentialContraints = 9,
        adSchemaSchemata = 17,
        adSchemaSets = 43,
        adSchemaSQLLanguages = 18,
        adSchemaStatistics = 19,
        adSchemaTableConstraints = 10,
        adSchemaTablePrivileges = 14,
        adSchemaTables = 20,
        adSchemaTranslations = 21,
        adSchemaTrustees = 39,
        adSchemaUsagePrivileges = 15,
        adSchemaViewColumnUsage = 24,
        adSchemaViews = 23,
        adSchemaViewTableUsage = 25,
    }

    const enum SearchDirection {
        adSearchBackward = -1,
        adSearchForward = 1,
    }

    const enum SearchDirectionEnum {
        adSearchBackward = -1,
        adSearchForward = 1,
    }

    const enum SeekEnum {
        adSeekAfter = 8,
        adSeekAfterEQ = 4,
        adSeekBefore = 32,
        adSeekBeforeEQ = 16,
        adSeekFirstEQ = 1,
        adSeekLastEQ = 2,
    }

    const enum StreamOpenOptionsEnum {
        adOpenStreamAsync = 1,
        adOpenStreamFromRecord = 4,
        adOpenStreamUnspecified = -1,
    }

    const enum StreamReadEnum {
        adReadAll = -1,
        adReadLine = -2,
    }

    const enum StreamTypeEnum {
        adTypeBinary = 1,
        adTypeText = 2,
    }

    const enum StreamWriteEnum {
        adWriteChar = 0,
        adWriteLine = 1,
        stWriteChar = 0,
        stWriteLine = 1,
    }

    const enum StringFormatEnum {
        adClipString = 2,
    }

    const enum XactAttributeEnum {
        adXactAbortRetaining = 262144,
        adXactAsyncPhaseOne = 524288,
        adXactCommitRetaining = 131072,
        adXactSyncPhaseOne = 1048576,
    }

    class Bookmark {
        private 'ADODB.Bookmark_typekey': Bookmark;
        private constructor();
    }

    class Command {
        private 'ADODB.Command_typekey': Command;
        private constructor();

        /**
         * Sets or returns a String value that contains a definition for a connection if the connection is closed, or a Variant containing the current Connection object if the connection is open. Default is a null object reference.
         */
        ActiveConnection: string | Connection | null;
        Cancel(): void;
        CommandStream: any;
        CommandText: string;
        CommandTimeout: number;
        CommandType: CommandTypeEnum;

        /**
         * @param Name [Name='']
         * @param Type [Type=0]
         * @param Direction [Direction=1]
         * @param Size [Size=0]
         */
        CreateParameter(Name?: string, Type?: DataTypeEnum, Direction?: ParameterDirectionEnum, Size?: number, Value?: any): Parameter;
        Dialect: string;

        /**
         * @param Options [Options=-1]
         *
         * The **RecordsAffected** parameter is meant to take a variable to be modified by reference, which is not supported by Javascript
         *
         * The return value is as follows:
         *
         * * If the **adExecuteNoRecords** option is passed in, the method will return `null`. Otherwise:
         * * If the command specifies a row-returning query, then the method will return a new read-only, forward-only **Recordset** object with the results.
         * * If the command isn't intended to return results (e.g. an `UPDATE` statement), a closed empty **Recordset** will be returned.
         */
        Execute(RecordsAffected?: undefined, Parameters?: SafeArray, Options?: number): Recordset | null;
        Name: string;
        NamedParameters: boolean;
        readonly Parameters: Parameters;
        Prepared: boolean;
        readonly Properties: Properties;
        readonly State: ObjectStateEnum;
    }

    class Connection {
        private 'ADODB.Connection_typekey': Connection;
        private constructor();

        /** Sum of one or more of the values in the **XactAttributeEnum** enum */
        Attributes: XactAttributeEnum;
        BeginTrans(): number;
        Cancel(): void;
        Close(): void;
        CommandTimeout: number;
        CommitTrans(): void;
        ConnectionString: string;
        ConnectionTimeout: number;
        CursorLocation: CursorLocationEnum;
        DefaultDatabase: string;
        readonly Errors: Errors;

        /**
         * @param Options [Options=-1]
         *
         * The **RecordsAffected** parameter is meant to take a variable to be modified by reference, which is not supported by Javascript
         *
         * The return value is as follows:
         *
         * * If the **adExecuteNoRecords** option is passed in, the method will return `null`. Otherwise:
         * * If **CommandText** specifies a row-returning query, then the method will return a new read-only, forward-only **Recordset** object with the results
         * * If **CommandText** isn't intended to return results (e.g. an `UPDATE` statement), a closed empty **Recordset** will be returned.
         */
        Execute(CommandText: string, RecordsAffected?: undefined, Options?: CommandTypeEnum | ExecuteOptionEnum): Recordset | null;
        IsolationLevel: IsolationLevelEnum;
        Mode: ConnectModeEnum;

        /**
         * @param ConnectionString [ConnectionString='']
         * @param UserID [UserID='']
         * @param Password [Password='']
         * @param Options [Options=-1]
         */
        Open(ConnectionString?: string, UserID?: string, Password?: string, Options?: number): void;

        /**
         * Returns a Recordset object that contains schema information
         * @param Schema Type of schema query to run
         * @param Restrictions A SafeArray of query constraints; depends on the [type of the schema query](https://msdn.microsoft.com/en-us/library/jj249359.aspx)
         */
        OpenSchema(Schema: SchemaEnum, Restrictions?: SafeArray<string>): Recordset;

        /**
         * Returns a Recordset object that contains schema information, for a provider-specific schema query type
         * @param SchemaID The GUID for a provider-schema query not defined by the OLE DB specification.
         */
        OpenSchema(Schema: SchemaEnum.adSchemaProviderSpecific, Restrictions: SafeArray<string>, SchemaID: string): Recordset;
        readonly Properties: Properties;
        Provider: string;
        RollbackTrans(): void;
        readonly State: ObjectStateEnum;
        readonly Version: string;
    }

    class Error {
        private 'ADODB.Error_typekey': Error;
        private constructor();
        readonly Description: string;
        readonly HelpContext: number;
        readonly HelpFile: string;
        readonly NativeError: number;
        readonly Number: number;
        readonly Source: string;
        readonly SQLState: string;
    }

    interface Errors {
        Clear(): void;
        readonly Count: number;
        Item(Index: any): Error;
        Refresh(): void;
        (Index: any): Error;
    }

    class Field {
        private 'ADODB.Field_typekey': Field;
        private constructor();
        readonly ActualSize: number;
        AppendChunk(Data: any): void;

        /** Sum of one or more of the values in the **FieldAttributeEnum** enum */
        Attributes: FieldAttributeEnum;
        DataFormat: any;
        DefinedSize: number;
        GetChunk(Length: number): any;
        readonly Name: string;
        NumericScale: number;
        readonly OriginalValue: any;
        Precision: number;
        readonly Properties: Properties;
        readonly Status: number;
        Type: DataTypeEnum;
        readonly UnderlyingValue: any;
        Value: any;
    }

    interface Fields {
        /**
         * @param DefinedSize [DefinedSize=0]
         * @param Attrib [Attrib=-1]
         */
        _Append(Name: string, Type: DataTypeEnum, DefinedSize?: number, Attrib?: FieldAttributeEnum): void;

        /**
         * @param DefinedSize [DefinedSize=0]
         * @param Attrib [Attrib=-1]
         */
        Append(Name: string, Type: DataTypeEnum, DefinedSize?: number, Attrib?: FieldAttributeEnum, FieldValue?: any): void;
        CancelUpdate(): void;
        readonly Count: number;
        Delete(Index: string | number): void;
        Item(Index: string | number): Field;
        Refresh(): void;

        /** @param ResyncValues [ResyncValues=2] */
        Resync(ResyncValues?: ResyncEnum): void;
        Update(): void;
        (Index: string | number): Field;
    }

    class Parameter {
        private 'ADODB.Parameter_typekey': Parameter;
        private constructor();
        AppendChunk(Val: any): void;

        /** Sum of one or more of the values in the **ParameterAttributesEnum** enum */
        Attributes: ParameterAttributesEnum;
        Direction: ParameterDirectionEnum;
        Name: string;
        NumericScale: number;
        Precision: number;
        readonly Properties: Properties;
        Size: number;
        Type: DataTypeEnum;
        Value: any;
    }

    interface Parameters {
        Append(Object: any): void;
        readonly Count: number;
        Delete(Index: string | number): void;
        Item(Index: string | number): Parameter;
        Refresh(): void;
        (Index: string | number): Parameter;
    }

    interface Properties {
        readonly Count: number;
        Item(Index: string | number): Property;
        Refresh(): void;
        (Index: string | number): Property;
    }

    class Property {
        private 'ADODB.Property_typekey': Property;
        private constructor();

        /** Sum of one or more of the values in the **PropertyAttributesEnum** enum */
        Attributes: PropertyAttributesEnum;
        readonly Name: string;
        readonly Type: DataTypeEnum;
        Value: any;
    }

    class Record {
        private 'ADODB.Record_typekey': Record;
        private constructor();

        /**
         * Sets or returns a String value that contains a definition for a connection if the connection is closed, or a Variant containing the current Connection object if the connection is open. Default is a null object reference.
         */
        ActiveConnection: string | Connection | null;
        Cancel(): void;
        Close(): void;

        /**
         * @param Source [Source='']
         * @param Destination [Destination='']
         * @param UserName [UserName='']
         * @param Password [Password='']
         * @param Options [Options=-1]
         * @param Async [Async=false]
         */
        CopyRecord(Source?: string, Destination?: string, UserName?: string, Password?: string, Options?: CopyRecordOptionsEnum, Async?: boolean): string;

        /**
         * @param Source [Source='']
         * @param Async [Async=false]
         */
        DeleteRecord(Source?: string, Async?: boolean): void;
        readonly Fields: Fields;
        GetChildren(): Recordset;
        Mode: ConnectModeEnum;

        /**
         * @param Source [Source='']
         * @param Destination [Destination='']
         * @param UserName [UserName='']
         * @param Password [Password='']
         * @param Options [Options=-1]
         * @param Async [Async=false]
         */
        MoveRecord(Source?: string, Destination?: string, UserName?: string, Password?: string, Options?: MoveRecordOptionsEnum, Async?: boolean): string;

        /**
         * Source may be:
         * * A URL. If the protocol for the URL is http, then the Internet Provider will be invoked by default. If the URL points to a node that contains an executable script (such as an .ASP page), then a Record containing the source rather than the executed contents is opened by default. Use the Options argument to modify this behavior.
         * * A Record object. A Record object opened from another Record will clone the original Record object.
         * * A Command object. The opened Record object represents the single row returned by executing the Command. If the results contain more than a single row, the contents of the first row are placed in the record and an error may be added to the Errors collection.
         * * A SQL SELECT statement. The opened Record object represents the single row returned by executing the contents of the string. If the results contain more than a single row, the contents of the first row are placed in the record and an error may be added to the Errors collection.
         * * A table name.
         *
         * @param Mode [Mode=0]
         * @param CreateOptions [CreateOptions=-1]
         * @param Options [Options=-1]
         * @param UserName [UserName='']
         * @param Password [Password='']
         */
        Open(Source?: string | Record | Recordset | Command, ActiveConnection?: string | Connection, Mode?: ConnectModeEnum, CreateOptions?: RecordCreateOptionsEnum, Options?: RecordOpenOptionsEnum, UserName?: string, Password?: string): void;
        readonly ParentURL: string;
        readonly Properties: Properties;
        readonly RecordType: RecordTypeEnum;
        Source: string | Recordset | Command;
        readonly State: ObjectStateEnum;
    }

    interface Recordset {
        _xClone(): Recordset;

        /** @param AffectRecords [AffectRecords=3] */
        _xResync(AffectRecords?: AffectEnum): void;

        /**
         * @param FileName [FileName='']
         * @param PersistFormat [PersistFormat=0]
         */
        _xSave(FileName?: string, PersistFormat?: PersistFormatEnum): void;
        AbsolutePage: PositionEnum;
        AbsolutePosition: PositionEnum;
        readonly ActiveCommand?: Command;

        /**
         * Sets or returns a String value that contains a definition for a connection if the connection is closed, or a Variant containing the current Connection object if the connection is open. Default is a null object reference.
         */
        ActiveConnection: string | Connection | null;
        AddNew(): void;
        AddNew(Fields: SafeArray<string | number>, Values: SafeArray): void;
        AddNew(Field: string, Value: any): void;
        readonly BOF: boolean;
        Bookmark: Bookmark;
        CacheSize: number;
        Cancel(): void;

        /** @param AffectRecords [AffectRecords=3] */
        CancelBatch(AffectRecords?: AffectEnum): void;
        CancelUpdate(): void;

        /** @param LockType [LockType=-1] */
        Clone(LockType?: LockTypeEnum): Recordset;
        Close(): void;
        Collect(Index: any): any;
        CompareBookmarks(Bookmark1: Bookmark, Bookmark2: Bookmark): CompareEnum;
        CursorLocation: CursorLocationEnum;
        CursorType: CursorTypeEnum;
        DataMember: string;
        DataSource: any;

        /** @param AffectRecords [AffectRecords=1] */
        Delete(AffectRecords?: AffectEnum): void;
        readonly EditMode: EditModeEnum;
        readonly EOF: boolean;
        readonly Fields: Fields;

        /**
         * Sets or returns one of the following:
         * * Criteria string — a string made up of one or more individual clauses concatenated with AND or OR operators.
         * * Array of bookmarks — an array of unique bookmark values that point to records in the Recordset object.
         * * A FilterGroupEnum value
         */
        Filter: string | SafeArray<Bookmark> | FilterGroupEnum;

        /**
         * @param SkipRecords [SkipRecords=0]
         * @param SearchDirection [SearchDirection=1]
         */
        Find(Criteria: string, SkipRecords?: number, SearchDirection?: SearchDirectionEnum, Start?: Bookmark): void;

        /** @param Rows [Rows=-1] */
        GetRows(Rows?: number, Start?: string | Bookmark | BookmarkEnum, Fields?: string | SafeArray<string | number>): SafeArray;

        /**
         * @param StringFormat [StringFormat=2]
         * @param NumRows [NumRows=-1]
         * @param ColumnDelimeter [ColumnDelimeter='']
         * @param RowDelimeter [RowDelimeter='']
         * @param NullExpr [NullExpr='']
         */
        GetString(StringFormat?: StringFormatEnum, NumRows?: number, ColumnDelimeter?: string, RowDelimeter?: string, NullExpr?: string): string;
        Index: string;
        LockType: LockTypeEnum;
        MarshalOptions: MarshalOptionsEnum;
        MaxRecords: number;
        Move(NumRecords: number, Start?: string | Bookmark | BookmarkEnum): void;
        MoveFirst(): void;
        MoveLast(): void;
        MoveNext(): void;
        MovePrevious(): void;

        /** Since Javascript doesn't support byref parameters, the RecordsAffected parameter cannot be used */
        NextRecordset(): Recordset;

        /**
         * @param CursorType [CursorType=-1]
         * @param LockType [LockType=-1]
         * @param Options [Options=-1]
         */
        Open(Source: Command, ActiveConnection: null, CursorType?: CursorTypeEnum, LockType?: LockTypeEnum, Options?: CommandTypeEnum | ExecuteOptionEnum): void;
        Open(Source?: Stream): void;

        /**
         * @param CursorType [CursorType=-1]
         * @param LockType [LockType=-1]
         * @param Options [Options=-1]
         */
        Open(Source: string, ActiveConnection: string | Connection, CursorType?: CursorTypeEnum, LockType?: LockTypeEnum, Options?: CommandTypeEnum | ExecuteOptionEnum): void;
        readonly PageCount: number;
        PageSize: number;
        readonly Properties: Properties;
        readonly RecordCount: number;

        /** @param Options [Options=-1] */
        Requery(Options?: number): void;

        /**
         * @param AffectRecords [AffectRecords=3]
         * @param ResyncValues [ResyncValues=2]
         */
        Resync(AffectRecords?: AffectEnum, ResyncValues?: ResyncEnum): void;

        /** @param PersistFormat [PersistFormat=0] */
        Save(Destination: string | Stream, PersistFormat?: PersistFormatEnum): void;

        /**
         * @param SeekOption [SeekOption=1]
         *
         * For a single-column index, pass in a single value to seek in the column of the index
         *
         * For a multi-column index, pass in a SafeArray containing the multiple values to seek in the columns of the index.
         */
        Seek(KeyValues: any, SeekOption?: SeekEnum): void;
        Sort: string;
        Source: string | Command;
        readonly State: ObjectStateEnum;
        readonly Status: number;
        StayInSync: boolean;
        Supports(CursorOptions: CursorOptionEnum): boolean;
        Update(): void;
        Update(Fields: SafeArray<string | number>, Values: SafeArray): void;
        Update(Field: string, Value: any): void;

        /** @param AffectRecords [AffectRecords=3] */
        UpdateBatch(AffectRecords?: AffectEnum): void;
        (FieldIndex: string | number): Field;
    }

    class Stream {
        private 'ADODB.Stream_typekey': Stream;
        private constructor();
        Cancel(): void;
        Charset: string;
        Close(): void;

        /** @param CharNumber [CharNumber=-1] */
        CopyTo(DestStream: Stream, CharNumber?: number): void;
        readonly EOS: boolean;
        Flush(): void;
        LineSeparator: LineSeparatorEnum;
        LoadFromFile(FileName: string): void;
        Mode: ConnectModeEnum;

        /**
         * @param Mode [Mode=0]
         * @param Options [Options=-1]
         * @param UserName [UserName='']
         * @param Password [Password='']
         */
        Open(Source?: string | Record, Mode?: ConnectModeEnum, Options?: StreamOpenOptionsEnum, UserName?: string, Password?: string): void;
        Position: number;

        /** @param NumBytes [NumBytes=-1] */
        Read(NumBytes?: number): any;

        /** @param NumChars [NumChars=-1] */
        ReadText(NumChars?: number): string;

        /** @param Options [Options=1] */
        SaveToFile(FileName: string, Options?: SaveOptionsEnum): void;
        SetEOS(): void;
        readonly Size: number;
        SkipLine(): void;
        readonly State: ObjectStateEnum;
        Type: StreamTypeEnum;
        Write(Buffer: any): void;

        /** @param Options [Options=0] */
        WriteText(Data: string, Options?: StreamWriteEnum): void;
    }

    namespace EventHelperTypes {
        type Connection_ExecuteComplete_ArgNames = ['RecordsAffected', 'pError', 'adStatus', 'pCommand', 'pRecordset', 'pConnection'];

        type Connection_WillConnect_ArgNames = ['ConnectionString', 'UserID', 'Password', 'Options', 'adStatus', 'pConnection'];

        type Connection_WillExecute_ArgNames = ['Source', 'CursorType', 'LockType', 'Options', 'adStatus', 'pCommand', 'pRecordset', 'pConnection'];

        interface Connection_ExecuteComplete_Parameter {
            adStatus: EventStatusEnum;
            readonly pCommand: Command;
            readonly pConnection: Connection;
            readonly pError: Error;
            readonly pRecordset: Recordset;
            readonly RecordsAffected: number;
        }

        interface Connection_WillConnect_Parameter {
            adStatus: EventStatusEnum;
            ConnectionString: string;
            Options: number;
            Password: string;
            readonly pConnection: Connection;
            UserID: string;
        }

        interface Connection_WillExecute_Parameter {
            adStatus: EventStatusEnum;
            CursorType: CursorTypeEnum;
            LockType: LockTypeEnum;
            Options: number;
            readonly pCommand: Command;
            readonly pConnection: Connection;
            readonly pRecordset: Recordset;
            Source: string;
        }
    }
}

interface ActiveXObject {
    on(obj: ADODB.Connection, event: 'BeginTransComplete', argNames: ['TransactionLevel', 'pError', 'adStatus', 'pConnection'], handler: (this: ADODB.Connection, parameter: {readonly TransactionLevel: number, readonly pError: ADODB.Error, adStatus: ADODB.EventStatusEnum, readonly pConnection: ADODB.Connection}) => void): void;
    on(obj: ADODB.Connection, event: 'CommitTransComplete' | 'ConnectComplete' | 'InfoMessage' | 'RollbackTransComplete', argNames: ['pError', 'adStatus', 'pConnection'], handler: (this: ADODB.Connection, parameter: {readonly pError: ADODB.Error, adStatus: ADODB.EventStatusEnum, readonly pConnection: ADODB.Connection}) => void): void;
    on(obj: ADODB.Connection, event: 'Disconnect', argNames: ['adStatus', 'pConnection'], handler: (this: ADODB.Connection, parameter: {adStatus: ADODB.EventStatusEnum, readonly pConnection: ADODB.Connection}) => void): void;
    on(obj: ADODB.Connection, event: 'ExecuteComplete', argNames: ADODB.EventHelperTypes.Connection_ExecuteComplete_ArgNames, handler: (this: ADODB.Connection, parameter: ADODB.EventHelperTypes.Connection_ExecuteComplete_Parameter) => void): void;
    on(obj: ADODB.Connection, event: 'WillConnect', argNames: ADODB.EventHelperTypes.Connection_WillConnect_ArgNames, handler: (this: ADODB.Connection, parameter: ADODB.EventHelperTypes.Connection_WillConnect_Parameter) => void): void;
    on(obj: ADODB.Connection, event: 'WillExecute', argNames: ADODB.EventHelperTypes.Connection_WillExecute_ArgNames, handler: (this: ADODB.Connection, parameter: ADODB.EventHelperTypes.Connection_WillExecute_Parameter) => void): void;
    on(obj: ADODB.Recordset, event: 'EndOfRecordset', argNames: ['fMoreData', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {fMoreData: boolean, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'FetchComplete', argNames: ['pError', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly pError: ADODB.Error, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'FetchProgress', argNames: ['Progress', 'MaxProgress', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly Progress: number, readonly MaxProgress: number, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'FieldChangeComplete', argNames: ['cFields', 'Fields', 'pError', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly cFields: number, readonly Fields: any, readonly pError: ADODB.Error, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'MoveComplete' | 'RecordsetChangeComplete', argNames: ['adReason', 'pError', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly adReason: ADODB.EventReasonEnum, readonly pError: ADODB.Error, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'RecordChangeComplete', argNames: ['adReason', 'cRecords', 'pError', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly adReason: ADODB.EventReasonEnum, readonly cRecords: number, readonly pError: ADODB.Error, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'WillChangeField', argNames: ['cFields', 'Fields', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly cFields: number, readonly Fields: any, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'WillChangeRecord', argNames: ['adReason', 'cRecords', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly adReason: ADODB.EventReasonEnum, readonly cRecords: number, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    on(obj: ADODB.Recordset, event: 'WillChangeRecordset' | 'WillMove', argNames: ['adReason', 'adStatus', 'pRecordset'], handler: (this: ADODB.Recordset, parameter: {readonly adReason: ADODB.EventReasonEnum, adStatus: ADODB.EventStatusEnum, readonly pRecordset: ADODB.Recordset}) => void): void;
    set(obj: ADODB.Recordset, propertyName: 'Collect', parameterTypes: [any], newValue: any): void;
}

interface ActiveXObjectNameMap {
    'ADODB.Command': ADODB.Command;
    'ADODB.Connection': ADODB.Connection;
    'ADODB.Parameter': ADODB.Parameter;
    'ADODB.Record': ADODB.Record;
    'ADODB.Recordset': ADODB.Recordset;
    'ADODB.Stream': ADODB.Stream;
}