I want to execute a query in a thread. but program crash in the oraoledb. does oraoledb.oracle support thread call? when I use MSDAORA, the program runs well, but MSDAORA does not support BLOB in oracle 8i. I have to choose ORAOLEDB. one more, when I move the query code to run in main thread, it works well too, it almost drove me crazy.

my codes in thread looks like following.did i miss some properties?

CCommand<CDynamicAccessor, CRowset> command;
HRESULT hr = command.Open(theApp.m_Session, strSQL, &propset, NULL, DBGUID_DEFAULT, false);