asynchronous connection w/ odbc to ms sql database -- C Coding

My current program, connects to the database synchronously. It uploads the data and can pull down the records it needs.

I have been given the task of making the connection asynchrounous.

I have the latest ODBC 3.8 and Windows 7 which does support the asynchronous connections (pooling method).

Can anyone point me in the right direction or maybe a piece of sample code?

This example shows how to use SQLSetConnectAttr to enable asynchronous execution for connection-related functions.

Code:

---




BOOL AsyncConnect (SQLHANDLE hdbc)
{

    SQLRETURN r;
    SQLHANDLE hdbc;

    // Enable asynchronous execution of connection functions.
// This must be executed synchronously, that is r != SQL_STILL_EXECUTING

  r = SQLSetConnectAttr(hdbc, SQL_ATTR_ASYNC_DBC_FUNCTIONS_ENABLE,
        reinterpret_cast<SQLPOINTER>(SQL_ASYNC_DBC_ENABLE_ON), 0);

    if (r != SQL_SUCCESS && r != SQL_SUCCESS_WITH_INFO)
    {
      return FALSE;
    }


    TCHAR szConnStrIn[256] = _T("DSN=AsyncDemo");
    r = SQLDriverConnect(hdbc, NULL, (SQLTCHAR *) szConnStrIn, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT);

    if (r == SQL_ERROR)
    {
      // Use SQLGetDiagRec to process the error.
// If SQLState is HY114, the driver does not support asynchronous execution.
return FALSE;
    }


    while (r == SQL_STILL_EXECUTING)
    {
      // Do something else.
// Check for completion, with the same set of arguments.

      r = SQLDriverConnect(hdbc, NULL, (SQLTCHAR *) szConnStrIn, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT);
    }

    if (r != SQL_SUCCESS && r != SQL_SUCCESS_WITH_INFO)
    {
      return FALSE;
    }
    return TRUE;
}


---