| Previous | Next |
| DB_E_CHAPTERNOTRELEASED | DB_E_PARAMUNAVAILABLE |
DB_E_BADSOURCEHANDLE
Source handle is invalid
Exact value and result class
DB_E_BADSOURCEHANDLE has unsigned value 2147749456 (0x80040E50) and signed 32-bit value -2147217840. AllStat describes it as “Source handle is invalid”. In this result, a provider receives a source handle that is invalid for the current source object or operation; the public text does not identify a single owning API.
The high bit is set, so DB_E_BADSOURCEHANDLE is a failure HRESULT. Its facility is 4 (FACILITY_ITF) and its low code is 3664 (0x0E50). For DB_E_BADSOURCEHANDLE, these fields identify an interface-defined result family; they do not identify the provider instance, method, object generation or partial effects.
Contract boundary
For DB_E_BADSOURCEHANDLE, storage-object access transfers COM interface pointers for long or object-valued data. For DB_E_BADSOURCEHANDLE, some providers allow only one live storage object for a row or source, and every returned handle or interface remains scoped to the object and operation that created it.
Investigation of DB_E_BADSOURCEHANDLE should start with the row, source handle and every open ISequentialStream, IStream or provider-specific storage interface. Capture DB_E_BADSOURCEHANDLE before ADO, ATL, .NET or a database abstraction layer replaces the native HRESULT with a generic exception.
Conditions that specifically lead to this result
- Cause 1 for
DB_E_BADSOURCEHANDLE: the handle was released or never initialized. - Cause 2 for
DB_E_BADSOURCEHANDLE: the handle belongs to another provider object or generation. - Cause 3 for
DB_E_BADSOURCEHANDLE: a numeric copy of a provider-owned handle crossed an invalid lifetime boundary.
Evidence to collect
A useful DB_E_BADSOURCEHANDLE event records provider CLSID and version, process architecture, interface IID and method, object correlation ID, transaction state and the immediately preceding HRESULT. When recording DB_E_BADSOURCEHANDLE data involving BLOB contents, object URLs and storage metadata, use types, lengths, hashes or redacted identifiers rather than secrets or complete business data.
- Evidence 1 for
DB_E_BADSOURCEHANDLE: the exact IID and method accepting the source handle. - Evidence 2 for
DB_E_BADSOURCEHANDLE: the object that originally issued the handle. - Evidence 3 for
DB_E_BADSOURCEHANDLE: creation, transfer and release events for that handle.
Diagnostic sequence
- Capture raw
0x80040E50and symbolicDB_E_BADSOURCEHANDLEat the native call boundary. - Identify the exact failing stage for
DB_E_BADSOURCEHANDLE: a provider receives a source handle that is invalid for the current source object or operation; the public text does not identify a single owning API. - Retrieve all OLE DB error records for
DB_E_BADSOURCEHANDLEbefore another COM call replaces thread error information. - Compare the live object state and provider-granted capabilities with the input that produced
DB_E_BADSOURCEHANDLE. - Reduce the
DB_E_BADSOURCEHANDLEoperation to the smallest case that preserves the same storage contract. - Apply one evidence-backed correction for
DB_E_BADSOURCEHANDLEand verify that the result is not merely replaced by a neighboring HRESULT.
Corrective actions
- Action 1 for
DB_E_BADSOURCEHANDLE: treat the source handle as opaque and object-scoped. - Action 2 for
DB_E_BADSOURCEHANDLE: reacquire it from the current source object. - Action 3 for
DB_E_BADSOURCEHANDLE: remove serialization or cross-object caching of provider handles.
Retry and recovery
Retry rule for DB_E_BADSOURCEHANDLE: retry only with a freshly issued handle whose owner and lifetime are proven. A DB_E_BADSOURCEHANDLE retry is safe only when the relevant input, object generation, capability or external state has changed. Before replaying a modifying call that returned DB_E_BADSOURCEHANDLE, determine whether rows, schema objects or URL resources were partially created or changed.
Do not turn DB_E_BADSOURCEHANDLE into an unbounded retry loop. Preserve cancellation for DB_E_BADSOURCEHANDLE and use a fresh provider object when the failed call may have left local state ambiguous.
Practical scenario
A cache stores a source handle after its view is rebuilt; reacquiring the handle from the new view prevents the invalid-source result. Keeping DB_E_BADSOURCEHANDLE with the method and object state makes this scenario diagnosable instead of reducing it to “database error”.
Difference from nearby HRESULT values
DB_E_BADROWHANDLE identifies an invalid HROW, while DB_E_BADSOURCEHANDLE refers to a different provider-defined source handle. Telemetry and remediation for DB_E_BADSOURCEHANDLE should keep these outcomes distinct.
Developer and operations guidance
Code handling DB_E_BADSOURCEHANDLE should release COM objects in ownership order, retain per-row, per-column or per-property statuses, and log granted capabilities rather than only requested options. While handling DB_E_BADSOURCEHANDLE, opaque values such as HACCESSOR, HROW, HCHAPTER, DBID components and provider handles must remain scoped to the object that issued them.
Operational dashboards for DB_E_BADSOURCEHANDLE should group by provider version, interface, method and normalized failure stage. A DB_E_BADSOURCEHANDLE event must not expose passwords, tokens, full connection strings, unrestricted command text or raw row contents.
Official Microsoft references
- Microsoft: OLE DB row objects — official documentation relevant to
DB_E_BADSOURCEHANDLE. - Microsoft: IRow — official documentation relevant to
DB_E_BADSOURCEHANDLE. - Microsoft: OLE DB interfaces — official documentation relevant to
DB_E_BADSOURCEHANDLE.
Looking for a different code? Search another status or error code.