Insert row with BLOB column with MSDASQL

Question

I have been struggling with this issue for a week, still can't get it working.

The situation is: I have a table with two columns:

PK: CHAR(4)
F1: BLOB

I can get the Select and Upate working, but don't know how to get INSERT working.

The INSERT action should happen in following query parameter binding way:

insert into table (pk, f1) values (?, ?)

I have read following question here: Inserting a blob with OLE DB But the problem is that with MSDASQL it seems the pIRowsetChange->InsertRow() method is NOT supported, so I can not use InsertRow() method.

Anyone can help me out of this headache? It's so urgent and I am really stuck in this.

Thanks millions if you can give me some hits or the best a sample program which demostrates insert a new row with both normal columns and blob column.