gwilym
asked on
hstmt error using RDO to call SQL from VB
When calling a SQl stored proc using RDO I get:
RunTime Error 40002
S1000: {Microsoft}{ODBC SQL Server Driver} Connection is busy with results for another hstmt
I know what an hstmt is (roughly!) but not how to solve this. I tried looping while rs.StillExecuting = True, and tested the other defined recordset in my routine from the command line, and neither where executing while the error came up.
Can you help???
RunTime Error 40002
S1000: {Microsoft}{ODBC SQL Server Driver} Connection is busy with results for another hstmt
I know what an hstmt is (roughly!) but not how to solve this. I tried looping while rs.StillExecuting = True, and tested the other defined recordset in my routine from the command line, and neither where executing while the error came up.
Can you help???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
see Q143032 in the KB too. (http://support.microsoft.com/kb/)