Multithreaded connections hanging problem

Hi all,
I am working on an application which should work for both SQLServer And Oracle.
It manages 2 threads. One for Executing a stored procedure which loops until a value is changed in a table. The other thread which uses a new separated connection, will set in this table the value on in order for the first stored proc to stop (and consequently terminates the first thread). The application containing the 2 threads is in VC++/ODBC3/Windows2000. Databses are SQLServer2000 or Oracle 8i.

This works good for SQLServer, but not for Oracle : the first thread works fine in both cases, but for Oracle the second thread never manages to connect, it hangs between the DataSource selection and Loging/Pwd window. A debugger stop shows that (when selecting the proper thread) the connection hangs on function AfxLockGlobals within the Db.Open->AllocConnect->AfxLockGlobals calls.

Is there a problem with static data in Oracle odbc ? As it is known that Oracle ODBC Driver does not support multiple statements with in the same connection. Here i really have 2 seperated connection in 2 different threads (2 different worker threads).
I 've tryed with both Oracle and Microsoft Oracle ODBC Driver but there is no difference.
Any clue ?
Thanks Received on Thu Jun 06 2002 - 10:32:35 CDT