We are using the Microsoft sql server dblib from
visual basic to make stored procedure calls
into an openserver and have noted the following behavour. The call
sqlrpcsend appears to block until rows are returned from the server. We
would have thought that we would not block waiting for returned rows until
calling sqlok. But we appear to be blocking on sqlrpcsend.
Question 1. Is this the correct behavour??
What we would like be able to do is start several long lasting rpc
call's simultaneously and wait for them all to return in parallel.
(Based upon what the open server is doing we should get overlap).
We think we should be able to do this by opening several dbproc's,
starting the rpc's by making all necessary calls up to and including
sqlrpcsend and then wait for each response by calling each sqlok one
after the other. If the block until sqlrpcsend
is the correct behavour, then this method seems to be a non-starter.
Question 2. Can we do this the way we'd like to, or is some
other method possible?
Any insights would be very, very, VERY helpful.
Thanks in advance,
FT Systems, Inc.