SQLHENV g_henv = SQL_NULL_HENV;
SQLHDBC g_hdbc = SQL_NULL_HDBC;
SQLHSTMT g_hstmt = SQL_NULL_HSTMT;
sqlreturn = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&g_henv);
sqlreturn = SQLSetEnvAttr(g_henv,SQL_ATTR_ODBC_VERSION,(void*) SQL_OV_ODBC3,NULL);
sqlreturn = SQLAllocHandle(SQL_HANDLE_DBC, g_henv,&g_hdbc);
sqlreturn = SQLDriverConnect(g_hdbc, GetForegroundWindow(), ConnectionStringIn, SQL_NTS, ConnectionStringOut, SQL_NTS, &StrOutSize, SQL_DRIVER_PROMPT);
sqlreturn = SQLAllocHandle(SQL_HANDLE_STMT,g_hdbc,&g_hstmt) ;
sqlreturn = SQLPrepare(g_hstmt,(PUCHAR)"select count(*) from table where id=?",SQL_NTS);
sqlreturn = SQLBindParameter(g_hstmt, 1 ,SQL_PARAM_INPUT,SQL_C_LONG,SQL_INTEGER, 0 , 0 ,&g_id, 0 , 0 );
sqlreturn = SQLBindCol(g_hstmt, 1 ,SQL_C_LONG,&g_count, 0 , 0 );
sqlreturn = SQLExecute(g_hstmt) ;
sqlstate = SQLFetch(g_hstmt);
//здесь имеем значение count(*) в g_count
SQLFreeStmt(g_hstmt,SQL_CLOSE);