CRecordset dynaset and CLongBinary problem


  • Hi,

    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.

    Thanks in advance for your help.


    Monday, February 06, 2012 3:35 PM

All replies

  • Hi,

    Would you please provide us a sample project to reproduce this issue?

    It is not necessary that you send out the whole of your project. We just need a simplest sample to reproduce the problem. You can remove any confidential information or business details from it.

    You can upload this project to skydriver

    Best regards,

    Jesse Jiang [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, February 08, 2012 9:53 AM