I don't have an answer but a shot in the dark. Let's assume that the SQLAllocStmt error is just that - an inablility to allocate memory for the statement. Where in the loop is the error occuring (after X number of loop iterations?). Is it possible to move the prepare_cached (with placeholders) outside the loop so you're not preparing it n times? Also, is the handles' finish being called before the next execute? (Probably). Some drivers have problems executing a still active handle.

-derby