If you don’t know about how to bulk import data into SQL Server with the
BULK INSERT statement, you can stop reading.
SQL Server Adapter (ODBC mode)
I have a situation where I am performing a BULK INSERT followed by a
I’m using the same connection from the same model object to do both
It seems like if I perform a BULK INSERT such that the # of rows that
I’m inserting > the batch size specified for the BULK INSERT, then my
DELETE fails with the dreaded: “Connection is busy with results for
another hstmt” ODBC error.
However, if the # of rows is smaller than the BULK INSERT batch size,
the DELETE goes through fine.
Does anyone have any insight into this? I don’t expect that anyone will
have any experience with this, but thought I might try for a long shot.