I am attempting to use a single CDatabase object across two threads. I have two different CRecordSet objects that are instantiated on the stack of each thread. The thread that hits the CRecordSet::Open command first is fine. The second thread throws a CDBException with the message:
"Connection is busy with results for another hstmt". The message appears to come from the ODBC driver itself. (SQL Server) I DO NOT wish to instantiate multiple CDatabase objects for each thread. How do I get around this?