Ado Konstanten
Zuletzt geändert: 14.03.2026 10:18

ADO-Konstanten für PowerShell #

PowerShell kennt keine eingebauten ADO-Konstanten. Wenn Sie über die Client.Connection-Eigenschaft direkt mit ADO-Recordsets arbeiten, müssen die Konstanten im Script deklariert werden.

Nachfolgend sind die wichtigsten ADO-Konstanten (ActiveX Data Objects) als PowerShell-Variablen aufgeführt. Eine Erklärung der einzelnen Konstantengruppen finden Sie unter ADO-Konstanten.

Cursor Type #

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

Lock Type #

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

Execute Options #

$adOptionUnspecified = -1
$adAsyncExecute = 0x10
$adAsyncFetch = 0x20
$adAsyncFetchNonBlocking = 0x40
# Wenn kein Recordset als Rückgabe erwartet wird,
# sollte diese Option angegeben werden, da sich die
# Ausführungsgeschwindigkeit hierdurch merkbar beschleunigt.
$adExecuteNoRecords = 0x80

Object State #

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

Cursor Location #

$adUseNone = 1
$adUseServer = 2
$adUseClient = 3

Datentypen #

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

Feld-Attribute #

$adFldUnspecified = -1
$adFldMayDefer = 0x2
$adFldUpdatable = 0x4
$adFldUnknownUpdatable = 0x8
$adFldFixed = 0x10
$adFldIsNullable = 0x20
$adFldMayBeNull = 0x40
$adFldLong = 0x80
$adFldRowID = 0x100
$adFldRowVersion = 0x200
$adFldCacheDeferred = 0x1000
$adFldKeyColumn = 0x8000

Edit Mode #

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

Record Status #

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

Command Type #

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

Connect Mode #

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

Parameter Direction #

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

Suchrichtung #

$adSearchForward = 1
$adSearchBackward = -1

Bookmark #

$adBookmarkCurrent = 0
$adBookmarkFirst = 1
$adBookmarkLast = 2

Fehler-Konstanten #

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