In manual-commit mode, calling SQLFreeHandle on a statement handle with an open transaction causes a rollback of pending changes to the database. SQLFreeHandle of a statement handle always closes any open cursors and discards pending results, freeing all resources associated with the statement handle.