Winscripter
  WSH
  Forums
  Downloads
  Books
  Links
  Amazon




Login
Register

© winscripter.com
1998-2004







ADO Constants - WSH JScript

Posted by on Sunday, January 18, 2004 (PST)

ADO Constants in WSH/JScript format.
//--------------------------------------------------------
// Microsoft ADO
//
// (c) 1996 Microsoft Corporation.  All Rights Reserved.
//
//
//
// ADO constants include file for JavaScript
//
//--------------------------------------------------------
//---- CursorTypeEnum Values ----
var adOpenForwardOnly = 0;
var adOpenKeyset      = 1;
var adOpenDynamic     = 2;
var adOpenStatic      = 3;
//---- CursorOptionEnum Values ----
var adHoldRecords    = 0x00000100;
var adMovePrevious   = 0x00000200;
var adAddNew         = 0x01000400;
var adDelete         = 0x01000800;
var adUpdate         = 0x01008000;
var adBookmark       = 0x00002000;
var adApproxPosition = 0x00004000;
var adUpdateBatch    = 0x00010000;
var adResync         = 0x00020000;
var adNotify         = 0x00040000;
//---- LockTypeEnum Values ----
var adLockReadOnly        = 1;
var adLockPessimistic     = 2;
var adLockOptimistic      = 3;
var adLockBatchOptimistic = 4;
//---- ExecuteOptionEnum Values ----
var adRunAsync = 0x00000010;
//---- ObjectStateEnum Values ----
var adStateClosed     = 0x00000000;
var adStateOpen       = 0x00000001;
var adStateConnecting = 0x00000002;
var adStateExecuting  = 0x00000004;
//---- CursorLocationEnum Values ----
var adUseServer = 2;
var adUseClient = 3;
//---- DataTypeEnum Values ----
var adEmpty            = 0;
var adTinyInt          = 16;
var adSmallInt         = 2;
var adInteger          = 3;
var adBigInt           = 20;
var adUnsignedTinyInt  = 17;
var adUnsignedSmallInt = 18;
var adUnsignedInt      = 19;
var adUnsignedBigInt   = 21;
var adSingle           = 4;
var adDouble           = 5;
var adCurrency         = 6;
var adDecimal          = 14;
var adNumeric          = 131;
var adBoolean          = 11;
var adError            = 10;
var adUserDefined      = 132;
var adVariant          = 12;
var adIDispatch        = 9;
var adIUnknown         = 13;
var adGUID             = 72;
var adDate             = 7;
var adDBDate           = 133;
var adDBTime           = 134;
var adDBTimeStamp      = 135;
var adBSTR             = 8;
var adChar             = 129;
var adVarChar          = 200;
var adLongVarChar      = 201;
var adWChar            = 130;
var adVarWChar         = 202;
var adLongVarWChar     = 203;
var adBinary           = 128;
var adVarBinary        = 204;
var adLongVarBinary    = 205;
//---- FieldAttributeEnum Values ----
var adFldMayDefer         = 0x00000002;
var adFldUpdatable        = 0x00000004;
var adFldUnknownUpdatable = 0x00000008;
var adFldFixed            = 0x00000010;
var adFldIsNullable       = 0x00000020;
var adFldMayBeNull        = 0x00000040;
var adFldLong             = 0x00000080;
var adFldRowID            = 0x00000100;
var adFldRowVersion       = 0x00000200;
var adFldCacheDeferred    = 0x00001000;
//---- EditModeEnum Values ----
var adEditNone       = 0x0000;
var adEditInProgress = 0x0001;
var adEditAdd        = 0x0002;
var adEditDelete     = 0x0004;
//---- RecordStatusEnum Values ----
var adRecOK                   = 0x0000000;
var adRecNew                  = 0x0000001;
var adRecModified             = 0x0000002;
var adRecDeleted              = 0x0000004;
var adRecUnmodified           = 0x0000008;
var adRecInvalid              = 0x0000010;
var adRecMultipleChanges      = 0x0000040;
var adRecPendingChanges       = 0x0000080;
var adRecCanceled             = 0x0000100;
var adRecCantRelease          = 0x0000400;
var adRecConcurrencyViolation = 0x0000800;
var adRecIntegrityViolation   = 0x0001000;
var adRecMaxChangesExceeded   = 0x0002000;
var adRecObjectOpen           = 0x0004000;
var adRecOutOfMemory          = 0x0008000;
var adRecPermissionDenied     = 0x0010000;
var adRecSchemaViolation      = 0x0020000;
var adRecDBDeleted            = 0x0040000;
//---- GetRowsOptionEnum Values ----
var adGetRowsRest = -1;
//---- PositionEnum Values ----
var adPosUnknown = -1;
var adPosBOF     = -2;
var adPosEOF     = -3;
//---- enum Values ----
var adBookmarkCurrent = 0;
var adBookmarkFirst   = 1;
var adBookmarkLast    = 2;
//---- MarshalOptionsEnum Values ----
var adMarshalAll          = 0;
var adMarshalModifiedOnly = 1;
//---- AffectEnum Values ----
var adAffectCurrent = 1;
var adAffectGroup   = 2;
var adAffectAll     = 3;
//---- FilterGroupEnum Values ----
var adFilterNone            = 0;
var adFilterPendingRecords  = 1;
var adFilterAffectedRecords = 2;
var adFilterFetchedRecords  = 3;
var adFilterPredicate       = 4;
//---- SearchDirection Values ----
var adSearchForward  = 1;
var adSearchBackward = -1;
//---- ConnectPromptEnum Values ----
var adPromptAlways           = 1;
var adPromptComplete         = 2;
var adPromptCompleteRequired = 3;
var adPromptNever            = 4;
//---- ConnectModeEnum Values ----
var adModeUnknown        = 0;
var adModeRead           = 1;
var adModeWrite          = 2;
var adModeReadWrite      = 3;
var adModeShareDenyRead  = 4;
var adModeShareDenyWrite = 8;
var adModeShareExclusive = 0xc;
var adModeShareDenyNone  = 0x10;
//---- IsolationLevelEnum Values ----
var adXactUnspecified     = 0xffffffff;
var adXactChaos           = 0x00000010;
var adXactReadUncommitted = 0x00000100;
var adXactBrowse          = 0x00000100;
var adXactCursorStability = 0x00001000;
var adXactReadCommitted   = 0x00001000;
var adXactRepeatableRead  = 0x00010000;
var adXactSerializable    = 0x00100000;
var adXactIsolated        = 0x00100000;
//---- XactAttributeEnum Values ----
var adXactCommitRetaining = 0x00020000;
var adXactAbortRetaining  = 0x00040000;
//---- PropertyAttributesEnum Values ----
var adPropNotSupported = 0x0000;
var adPropRequired     = 0x0001;
var adPropOptional     = 0x0002;
var adPropRead         = 0x0200;
var adPropWrite        = 0x0400;
//---- ErrorValueEnum Values ----
var adErrInvalidArgument     = 0xbb9;
var adErrNoCurrentRecord     = 0xbcd;
var adErrIllegalOperation    = 0xc93;
var adErrInTransaction       = 0xcae;
var adErrFeatureNotAvailable = 0xcb3;
var adErrItemNotFound        = 0xcc1;
var adErrObjectInCollection  = 0xd27;
var adErrObjectNotSet        = 0xd5c;
var adErrDataConversion      = 0xd5d;
var adErrObjectClosed        = 0xe78;
var adErrObjectOpen          = 0xe79;
var adErrProviderNotFound    = 0xe7a;
var adErrBoundToCommand      = 0xe7b;
var adErrInvalidParamInfo    = 0xe7c;
var adErrInvalidConnection   = 0xe7d;
var adErrStillExecuting      = 0xe7f;
var adErrStillConnecting     = 0xe81;
//---- ParameterAttributesEnum Values ----
var adParamSigned   = 0x0010;
var adParamNullable = 0x0040;
var adParamLong     = 0x0080;
//---- ParameterDirectionEnum Values ----
var adParamUnknown     = 0x0000;
var adParamInput       = 0x0001;
var adParamOutput      = 0x0002;
var adParamInputOutput = 0x0003;
var adParamReturnValue = 0x0004;
//---- CommandTypeEnum Values ----
var adCmdUnknown    = 0x0008;
var adCmdText       = 0x0001;
var adCmdTable      = 0x0002;
var adCmdStoredProc = 0x0004;
//---- SchemaEnum Values ----
var adSchemaProviderSpecific      = -1;
var adSchemaAsserts               = 0;
var adSchemaCatalogs              = 1;
var adSchemaCharacterSets         = 2;
var adSchemaCollations            = 3;
var adSchemaColumns               = 4;
var adSchemaCheckConstraints      = 5;
var adSchemaConstraintColumnUsage = 6;
var adSchemaConstraintTableUsage  = 7;
var adSchemaKeyColumnUsage        = 8;
var adSchemaReferentialContraints = 9;
var adSchemaTableConstraints      = 10;
var adSchemaColumnsDomainUsage    = 11;
var adSchemaIndexes               = 12;
var adSchemaColumnPrivileges      = 13;
var adSchemaTablePrivileges       = 14;
var adSchemaUsagePrivileges       = 15;
var adSchemaProcedures            = 16;
var adSchemaSchemata              = 17;
var adSchemaSQLLanguages          = 18;
var adSchemaStatistics            = 19;
var adSchemaTables                = 20;
var adSchemaTranslations          = 21;
var adSchemaProviderTypes         = 22;
var adSchemaViews                 = 23;
var adSchemaViewColumnUsage       = 24;
var adSchemaViewTableUsage        = 25;
var adSchemaProcedureParameters   = 26;
var adSchemaForeignKeys           = 27;
var adSchemaPrimaryKeys           = 28;
var adSchemaProcedureColumns      = 29;
 

Add Your Comment



WSH and ADSI Administrative Scripting

New Articles
  • List installed COM objects and associated ProgIDs
    Script: Lists all COM Objects and their associated ProgIDs (If available). Win32_ClassicCOMClassSetting

  • Script: File Rotator
    Script: Rotate files where the most current file has the lowest number in the archive. When files exceed the retention period, they are deleted. Typically used for log files, backups, etc..

  • Script: Create IIS Website and DNS record
    Script: Dan Casier sent me this script that will create a website and appropriate DNS record. The script is intended for Windows 2000 Server with local DNS and necessary DNS mof installed.


  • Winscripter   |  WSH   |  Forums   |  Downloads   |  Books   |  Links   |  Amazon