Very Computer

1. Getting "The cursor is already open"-error

Hi,
I have constructed an application in VB3 where I use a SQL Server database.
This problem occurs when I'm creating a temporary table with the help of a
store procedure.
In VB I am first Allocating a statmenthandler, then am I binding parameters
to the procedure and finaly executing following code:

    Retcode = SqlExecDirect(gHstmt, "{call <The Store Procedure>}", SQL_NTS)

    If Retcode <> SQL_SUCCESS Then
        <It returns SQL_SUCCESS, so I skip this part of the code>
    End If

After this am I stopping the work and free the memory associated to the
statmenthandler. The problem occurs when I runs the above descibed function
again. I guess that SQL Server return Ok to soon to VB so the cursor never
was closed. I have tried to put a delay before stopping and freeing the
memory to the statmenthandler, but if its a heavy process must the delay be
up to 20 seconds and that is way to long to be acceptable.
Thanks, Eric

2. How to identiy tables without indexes

3. vb conflict to open DB already open with Access (error 3356)

4. Help with Query

5. Preventing a from from being opened - if already open

6. collections and keys

7. Mail merge from Access try to open an already open DB

8. ODBC LIBRARY

9. Error opening file (already opened)

10. Development of "Glossary" Databse in VB6

11. "distribution agent already running" error

12. "Record already locked this session"

13. Access db "already in use" error