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.