ODBC and Multithread

[Steve McNeese]

In my ODBC application, I created a CDatabase object at the application level, open a connection to this database and use the resulting pointer to assign to any CRecordset objects m_pDatabase member variable that I use. This creates one connection to the database. My question is if I create a another thread in the application that needs to access a CRecordset object from the same database, do I need a separate CDatabase object and connection for the thread or should I use some sort of syncronization. Assigning the database to the CRecordset in the thread fails with an unhandled exception when the thread calls the Open method of the CRecordset. I am sure this is because both threads cannot access the same object, but I am new at this and learning.

Any information will be greatly appreciated.

Steven M. McNeese
steven.mcneese@boeing.com