Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: ODBC extender memory
Here's some background on how the ODBC extender works:
When you allocate an environment handle, Winbatch allocates memory and a logical cursor/pointer position, from a table that's loaded in memory.
You cannot reuse the Statement Handle when the cursor is in use in this memory table.
When this process is going on, there are still pending results (going on in memory).
Therefore, if you do an unbind when the cursor is still processing, you can get a GPF or memory error. This is because various other resources are still connected to the statement handle.
When Winbatch frees the statement handle, we disconnect and *then* free the connection handle.
We drop all statement handles after this, and discard all pending rows. So if you're still in the middle of processing (i.e., your pointer is still going through the rows), you could get a GPF error.
If you really want to free the statement handle, then you should use the qDisconnect function, which handles everything and kills it completely, thereby discarding all pending rows and handles.
Article ID: W12536
Filename: More on How ODBC Works.txt
File Created: 2017:07:28:12:58:32
Last Updated: 1999:04:15:15:47:54