To allocate an ODBC handle
Call the SQLAllocHandle function, which takes the following parameters:
An identifier for the type of item being allocated
The handle of the parent item
A pointer to the location of the handle to be allocated
For a full description, see SQLAllocHandle in the Microsoft ODBC Programmer's Reference.
Use the handle in subsequent function calls.
Free the object using SQLFreeHandle, which takes the following parameters:
An identifier for the type of item being freed
The handle of the item being freed
For a full description, see SQLFreeHandle in the Microsoft ODBC Programmer's Reference.
The following code fragment allocates and frees an environment handle:
SQLHENV env; SQLRETURN retcode; retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env ); if ( retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO ) { // success: application code here }