How to allocate ODBC handles

The handle types required for ODBC programs are as follows:

To use an ODBC handle, you perform the following tasks:

1. Call the SQLAllocHandle function.

2. Use the handle in subsequent function calls.

3. Free the object using SQLFreeHandle.

SQLAllocHandle 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 information, see SQLAllocHandle in the Microsoft ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms712455.aspx.

SQLFreeHandle takes the following parameters:

• an identifier for the type of item being freed

• the handle of the item being freed

  For information, see SQLFreeHandle in the Microsoft ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms710123.aspx.

SQLRETURN rc;
SQLHENV env;
rc = SQLAllocHandle( SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env ); 
if( rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO ) 
{
    .
    .
    .
}
SQLFreeHandle( SQL_HANDLE_ENV, env );