Hi Reuven,
Thanks for your response.

Regarding SQL_NO_DATA, This article,
http://msdn2.microsoft.com/en-us/lib...13(VS.85).aspx, does not say
it very clearly.
I also found some description regarding SQL_NO_DATA in getting long data:
Getting Long Data
http://msdn2.microsoft.com/en-us/lib...26(VS.85).aspx

However it is for ODBC API, not for CRecordset. To track the root cause of
this issue, we may need to reproduce your issue and perform some debugging.
If this issue can be easily reproduced at your side in a separated machine,
could you please mail me (changliw_at_microsoft_dot_com) your sample
project and your test database for further research? You may just import
the specific table to a test database, then backup the database and send it
to me. Appreciate your understanding that for such kind of issue, without
reproducing your issue and performing some debugging, it is hard for us to
perform effective research.

If this issue is not easily reproduced, to track the root cause, some
advanced troubleshooting technologies would be required and I recommend
that you contact Microsoft Customer Support Services (CSS) via telephone so
that a dedicated Support Professional can assist you in a more efficient
manner. Please be advised that contacting phone support will be a charged
call.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default...S;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======