ODBC Prepared Statement and triggers

[clvmiller]

I have an application which uses ODBC to insert, update, delete records in an MSSQL DB. The application uses prepared statements and keeps the odbc statement handles to execute the same statement multiple times.
This application works fine until triggers are introduced. The triggers are pretty simple and take the inserted, updated record and insert this information into another table.
If we change the application to not re-use the prepared statement handle, by closing the statement handle after each execute, it also works fine. (However, this results in bad performance.)

The error message is: "[ODBC SQL Server Driver]Connection is busy with results for another hstmt". If anyone has any information on this, I would greatly appreciate the help!!!

Thank you.
Christine

[sjimmo]

Try this making sure that the configuration option for nested triggers is set to 1.