| title | Descriptor Transitions | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 01/19/2017 | |||
| ms.prod | sql | |||
| ms.prod_service | connectivity | |||
| ms.reviewer | ||||
| ms.technology | connectivity | |||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 0cf24fe6-5e3c-45fa-81b8-4f52ddf8501d | |||
| author | David-Engel | |||
| ms.author | v-daenge |
ODBC descriptors have the following three states.
| State | Description |
|---|---|
| D0 | Unallocated descriptor |
| D1i | Implicitly allocated descriptor |
| D1e | Explicitly allocated descriptor |
The following tables show how each ODBC function affects the descriptor state.
| D0 Unallocated |
D1i Implicit |
D1e Explicit |
|---|---|---|
| D1i[1] | -- | -- |
| D1e[2] | -- | -- |
[1] This row shows transitions when HandleType was SQL_HANDLE_STMT.
[2] This row shows transitions when HandleType was SQL_HANDLE_DESC.
| D0 Unallocated |
D1i Implicit |
D1e Explicit |
|---|---|---|
| (IH) | -- | -- |
| D0 Unallocated |
D1i Implicit |
D1e Explicit |
|---|---|---|
| --[1] | D0 | -- |
| (IH)[2] | (HY017) | D0 |
[1] This row shows transitions when HandleType was SQL_HANDLE_STMT.
[2] This row shows transitions when HandleType was SQL_HANDLE_DESC.
| D0 Unallocated |
D1i Implicit |
D1e Explicit |
|---|---|---|
| (IH) | -- | -- |
| D0 Unallocated |
D1i Implicit |
D1e Explicit |
|---|---|---|
| (IH)[1] | -- | -- |
[1] This row shows transitions when DescriptorHandle was the handle of an ARD, APD, or IPD, or (for SQLSetDescField) when DescriptorHandle was the handle of an IRD and FieldIdentifier was SQL_DESC_ARRAY_STATUS_PTR or SQL_DESC_ROWS_PROCESSED_PTR.
| D0 Unallocated |
D1i Implicit |
D1e Explicit |
|---|---|---|
| -- | -- | -- |