Re: Reading BLOBs from SQL Server 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Arnie,

Thanks for your patience.

I setup a sample on my side to try to reproduce it on my side as below

if (retcode == SQL_SUCCESS)
{
while (TRUE)
{
retcode = SQLFetch(hstmt);
if (retcode == SQL_ERROR || retcode == SQL_SUCCESS_WITH_INFO)
{
return -1;
}
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{

/* Get data for columns 1, 2*/

SQLGetData(hstmt, 1, SQL_C_CHAR, szName, NAME_LEN, &cbName);
SQLGetData(hstmt, 2, SQL_C_CHAR, szAge, AGE_LEN, &cbAge);

/* Print the row of data */

} else {
break;
}
}
}

I used Profiler to trace the SQL Server and find there is only one trace in
the Profiler. Would you please generate a sample using Northwind database
that will show this kind of double query of the SQL Server when using ODBC
driver?

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.




.

Relevant Pages

  • Re: And the president is...
    ... today the majority who support this ... your point is very valid basil and we supported this dialogue after ... every which way that this is not some artificially imposed choice by ... today patience is costing us our very ...
    (soc.culture.lebanon)
  • Re: Problems creating distribution list
    ... > would you send your CSV file to me and let me do some more research on it. ... > Microsoft Online Partner Support ... > Business-Critical Phone Support (BCPS) provides you with technical phone ... > If you are outside the United States, ...
    (microsoft.public.exchange2000.clients)
  • Re: Block all Internet access except certain sites - Not working p
    ... >> Can you export your ISA server configuration to me to have a further ... >> Microsoft Online Partner Support ... >> Business-Critical Phone Support (BCPS) provides you with technical phone ... >> If you are outside the United States, ...
    (microsoft.public.windows.server.sbs)
  • RE: Changes made by one user are over written by another user
    ... > steps a-f to edit the css file and save it once more. ... > Microsoft Product Support Services ... > Business-Critical Phone Support (BCPS) provides you with technical phone ... > If you are outside the United States, ...
    (microsoft.public.sharepoint.portalserver.development)
  • RE: Finding people using Search
    ... > Microsoft Product Support Services ... > Business-Critical Phone Support (BCPS) provides you with technical phone ... > If you are outside the United States, ...
    (microsoft.public.sharepoint.portalserver.development)