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

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: Exporting XML file from SQL Server using FOR XML AUTO
    ... Sorry, this was not a bug, this was a design decision that you needed to ... > a bug with FOR...XML statements when executed over ODBC. ... > problems having IE 6.0 read the outputted format. ... Is there a way to avoid these random control linefeeds in the ...
    (microsoft.public.sqlserver.xml)
  • Re: DB_KEYANDMODIFIED BUG
    ... The other bug is the new value, which is off by a rounding error. ... What version of VFP are you using? ... >>> ODBC. ... >>> Denys Rodrigues ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Odd ADO.Resultset Buffer Problem?
    ... > old bug associated with using ODBC to retrieve data that includes Text data. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • =?iso-8859-2?Q?Re:_Cursoradapter_Bin=E4res_Memofeld_VPF9.0_SP1?=
    ... hast wohl einen Bug entdeckt. ... über den ODBC Datentyp SQL_LONGVARBINARY aktualisiert, ... dem der Visual FoxPro ODBC Treiber ... da der ODBC Treiber nicht mehr gepflegt wird. ...
    (microsoft.public.de.fox)
  • Re: Odd ADO.Resultset Buffer Problem?
    ... old bug associated with using ODBC to retrieve data that includes Text data. ... The best solution is to stop using ODBC and switch to using the native SQL ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)