Re: MS SQL Server ODBC Driver hanging code when using multiple active statements and SQLGetData

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

Hi Wen,

The work around is not to open or do anything with other statements until all the data for a column is fetched with SQLGetData. It would be nice if future versions of the SQL ODBC driver throw an exception.

What I'll need is a knowledge base article or something that describes the bug, even if it points out that there is no solution to it. It will olso be much easier for other ppl. in the future to diagnose this problem - I had to go through a log of trouble to find anything about it.

Thanks!

-- Todor

""WenYuan Wang"" <v-wywang@xxxxxxxxxxxxxxxxxxxx> wrote in message news:hDWROD3SHHA.2356@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Todor,
Thanks very much for your waiting.

I have consulted with our product team members. They have confirmed this
issue is an ODBC bug and created a bug record in the bug list. If we are
using ODBC driver for SQL server, we can only connect ->execute one
stmt->get ALL results->execute another stmt->get ALL results.
According the idea of product team, it seems next version of ODBC driver
will throw an exception instead of infinitely waiting. But I'm afraid this
issue will not be fixed immediately and there is no work around to this
issue now. I'm very sorry to hear that you're having such a painful
experience with ODBC driver. If there is anything we can help with, please
feel free to reply me. I'm glad to assist you.

Bug: sqlsrv32 waits infinitely when a result set is opened in another
statement handle.

Many thanks for your understanding!
Wen Yuan


.

Relevant Pages

  • RE: Protocol Error in TDS Stream vs Network Packet Size
    ... We reported this problem and finally we confirmed that it is a bug. ... For MSQuery, ODBC driver is used which has a problem in retrieving large ... the field definition for the recordset is too large to fit in one ...
    (microsoft.public.sqlserver.connect)
  • Re: MS SQL Server ODBC Driver hanging code when using multiple active statements and SQLGetData
    ... I have consulted with our product team members. ... issue is an ODBC bug and created a bug record in the bug list. ... According the idea of product team, it seems next version of ODBC driver ...
    (microsoft.public.data.odbc)
  • Re: ODBC SQLColums is very slow
    ... They turned down an earlier request to upgrade the ODBC driver, which currently might very well be a release 9. ... Do you have some more input on that bug? ...
    (comp.databases.oracle.server)
  • Re: ADO server side cursor sloooow
    ... Bill Bach wrote: ... Did they give you a Bug Number for tracking purposes? ... ODBC driver is the only Win32 driver that they have spent much time ... The performance of the PDAC components is pretty good but they appear ...
    (comp.databases.btrieve)
  • Re: WMP 11 Recently Added function...
    ... not being recognised correctly by WMP 11. ... collect data on this bug - and it can only be a bug. ... The Windows Media Player product team does not. ...
    (microsoft.public.windowsmedia.player)