ADO-Konstanten für VBScript #

VBScript kennt im Gegensatz zu VB6 keine eingebauten ADO-Konstanten. Wenn Sie mit Client.ExecuteSql oder der Client.Connection-Eigenschaft arbeiten und ADO-Konstanten benötigen, müssen diese im Script deklariert werden.

Nachfolgend sind die wichtigsten ADO-Konstanten (ActiveX Data Objects) als VBScript-Deklaration aufgeführt.

Cursor Type #

Const adOpenUnspecified = -1
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenDynamic = 2
Const adOpenStatic = 3

Lock Type #

Const adLockUnspecified = -1
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4

Execute Options #

Const adOptionUnspecified = -1
Const adAsyncExecute = &H10
Const adAsyncFetch = &H20
Const adAsyncFetchNonBlocking = &H40
' Wenn kein Recordset als Rückgabe erwartet wird,
' sollte diese Option angegeben werden, da sich die
' Ausführungsgeschwindigkeit hierdurch merkbar beschleunigt.
Const adExecuteNoRecords = &H80

Object State #

Const adStateClosed = 0
Const adStateOpen = 1
Const adStateConnecting = 2
Const adStateExecuting = 4
Const adStateFetching = 8

Cursor Location #

Const adUseNone = 1
Const adUseServer = 2
Const adUseClient = 3

Datentypen #

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

Feld-Attribute #

Const adFldUnspecified = -1
Const adFldMayDefer = &H2
Const adFldUpdatable = &H4
Const adFldUnknownUpdatable = &H8
Const adFldFixed = &H10
Const adFldIsNullable = &H20
Const adFldMayBeNull = &H40
Const adFldLong = &H80
Const adFldRowID = &H100
Const adFldRowVersion = &H200
Const adFldCacheDeferred = &H1000
Const adFldKeyColumn = &H8000

Edit Mode #

Const adEditNone = 0
Const adEditInProgress = 1
Const adEditAdd = 2
Const adEditDelete = 4

Record Status #

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

Command Type #

Const adCmdUnspecified = -1
Const adCmdUnknown = 8
Const adCmdText = 1
Const adCmdTable = 2
Const adCmdStoredProc = 4
Const adCmdFile = 256
Const adCmdTableDirect = 512

Connect Mode #

Const adModeUnknown = 0
Const adModeRead = 1
Const adModeWrite = 2
Const adModeReadWrite = 3
Const adModeShareDenyRead = 4
Const adModeShareDenyWrite = 8
Const adModeShareExclusive = 12
Const adModeShareDenyNone = 16

Parameter Direction #

Const adParamUnknown = 0
Const adParamInput = 1
Const adParamOutput = 2
Const adParamInputOutput = 3
Const adParamReturnValue = 4

Suchrichtung #

Const adSearchForward = 1
Const adSearchBackward = -1

Bookmark #

Const adBookmarkCurrent = 0
Const adBookmarkFirst = 1
Const adBookmarkLast = 2

Fehler-Konstanten #

Const adErrInvalidArgument = 3001
Const adErrNoCurrentRecord = 3021
Const adErrIllegalOperation = 3219
Const adErrInTransaction = 3246
Const adErrFeatureNotAvailable = 3251
Const adErrItemNotFound = 3265
Const adErrObjectInCollection = 3367
Const adErrObjectNotSet = 3420
Const adErrDataConversion = 3421
Const adErrObjectClosed = 3704
Const adErrObjectOpen = 3705
Const adErrProviderNotFound = 3706
Const adErrBoundToCommand = 3707
Const adErrInvalidParamInfo = 3708
Const adErrInvalidConnection = 3709
Const adErrNotReentrant = 3710
Const adErrStillExecuting = 3711
Const adErrOperationCancelled = 3712
Const adErrStillConnecting = 3713
Const adErrUnsafeOperation = 3716