| Previous | Next |
| DB_E_MISMATCHEDPROVIDER | DB_E_BADCONSTRAINTTYPE |
DB_E_BADCOMMANDID
Meaning
Windows documents DB_E_BADCOMMANDID as “DBID is invalid”. In this case, a command-persistence operation receives a DBID that is invalid under the provider command namespace.
Conditions that specifically lead to the result
- Cause 1: the DBID kind is unsupported for persisted commands.
- Cause 2: the identifier violates provider naming rules.
- Cause 3: a table or column DBID is supplied where a command DBID is required.
Relevant contract
Persisted OLE DB commands use DBIDs and persistence flags that are distinct from command text. A live command can execute successfully without having a persistent identity, and a persistent name is scoped to the provider namespace.
Investigation of this result should start with the command object, current DBID, persistence flags and provider namespace.
Diagnostic sequence
- Identify the exact failing stage: a command-persistence operation receives a DBID that is invalid under the provider command namespace.
Evidence to collect
When recording diagnostic data involving command text, persistent command names and schema identifiers, use types, lengths, hashes or redacted identifiers rather than secrets or complete business data.
- Evidence 1: full DBID kind and value.
- Evidence 2: provider literal and identifier capabilities.
- Evidence 3: the persistence method and flags.
Corrective actions
- Action 1: construct command IDs with provider-supported forms.
- Action 2: keep object-type-specific DBIDs separate.
- Action 3: validate names before saving or loading commands.
Practical scenario
A persistence layer passes a table DBID to a command loader; maintaining typed identifiers prevents it.
Retry and recovery
Retry rule: retry after replacing the command DBID with a valid provider-scoped identifier.
Difference from nearby HRESULT values
DB_E_COMMANDNOTPERSISTED means a command has no persistent ID, while DB_E_BADCOMMANDID means the supplied ID is invalid.
Official Microsoft references
Looking for a different code? Search another status or error code.