ODBC在ACCESS 中存取二进制

通过ODBC 操作ACCESS存取二进制文件，步骤如下：

sprintf(sql,"INSERT INTO image(image) VALUES(?)");//sql语言

len = SQL_DATA_AT_EXEC;//必须

SQLBindParameter(hstmt, 语句句柄

                               1, //绑定序号

                              SQL_PARAM_INPUT,

                                 SQL_C_BINARY,//C类型

                                  SQL_LONGVARBINARY,//SQL类型
                                 10000, //该字段的大小

                                 0,

                                 (SQLPOINTER) 2,

                                 0, &len);//变量绑定

rc = SQLExecute(hstmt);//执行语句

//通过SQLPutData 添加数据

 

while (rc == SQL_NEED_DATA)
    {
        rc = SQLParamData(hstmt, &pToken);
       if(rc == SQL_NEED_DATA)
       {

          。。。 //准备好要存的数据
           SQLPutData(hstmt, buffer, 100);//
       }
    }