TMSSQLConnection: only one active TSQLQuery?
lazarus / 16-Databases

----------------------------------------------------------------------
SymbolicFrank · 2023-06-27 12:11

If I open the second one (both for reading only), I get this error
message:

Code: Text  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
TMSSQLConnection : Error 20019 : Attempt to initiate a new Adaptive
Server operation with results pending
Is there a setting somewhere I'm missing?

----------------------------------------------------------------------
Чебурашка · 2023-06-27 13:05

I found this

https://forum.lazarus.freepascal.org/index.php/topic,32433.msg209322.h
tml#msg209322

Where LacaK tells some bits about opening a second query while the
previous is fetching, both on same conn


And this:

https://stackoverflow.com/questions/36706525/python-pymssql-attempt-
to-initiate-a-new-adaptive-server-operation-with-results