#include <sql.h>
#include <sqlext.h>
#include <stdio.h>

int main() {
    SQLHENV env;
    SQLHDBC dbc;
    SQLRETURN ret;
    SQLCHAR out[1024];
    SQLSMALLINT outLen;
    SQLCHAR dsn[] = "DRIVER={MySQL};SERVER=127.0.0.1;DATABASE=bugfix;USER=root;PASSWORD=;OPTION=0;CharSet=utf8";
    SQLHSTMT stmt;
    SQLCHAR column[2048];
    SQLLEN cbColumn, cbParam = 0;
    unsigned int val = 1;
    int i;

    const char* query = "SELECT my_column FROM my_table WHERE my_index = ?";

    SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, SQL_IS_UINTEGER);
    SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
    SQLDriverConnect(dbc, 0, dsn, SQL_NTS, out, sizeof(out), &outLen, SQL_DRIVER_COMPLETE);
    SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);
    SQLBindParameter(stmt, 1, SQL_PARAM_INPUT, SQL_C_ULONG, SQL_INTEGER, 0, 0, &val, 0, &cbParam);
    SQLExecDirect(stmt, (SQLCHAR*)query, SQL_NTS);
    SQLBindCol(stmt, 1, SQL_C_CHAR, column, 2048, &cbColumn);
    ret = SQLFetch(stmt);
    printf("return code: %i\n", ret);
}