I am trying to use a dynaset type of CRecordset that also stores and retrieves BLOB data using a bound CLongBinary member. When I call CRecordset::Open, I SQLExtendedFetch in the framework returns SQL_SUCCESS_WITH_INFO so MoveNext throws an exception
and the Open fails. This never happens when the CRecordset is set to type "snapshot". I want to stop using the snapshot type CRecordset so that I can avoid the cursor library, but I cannot get a dynaset CRecordset to work with CLongBinary.
Has anyone ever encountered this error? I am using Visual Studio 2010.