ODBC applications use a small set of handles to define basic features such as database connections and SQL statements. A handle is a 32-bit value.
The following handles are used in essentially all ODBC applications:
The following code illustrates how to allocate an environment handle:
SQLRETURN rc; SQLHENV env; rc = SQLAllocHandle( SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env );
The following code illustrates how to allocate a connection handle:
SQLRETURN rc; SQLHDBC dbc; rc = SQLAllocHandle( SQL_HANDLE_DBC, env, &dbc );
The following code illustrates how to allocate a statement handle:
SQLRETURN rc; SQLHSTMT stmt; rc = SQLAllocHandle( SQL_HANDLE_STMT, dbc, &stmt );