ODBC & Multithreading ...

From: K. Raghuraman <kraghu_at_india.hp.com>
Date: Thu, 22 Oct 1998 16:36:27 +0800
Message-ID: <362EEE8B.A975DA0D@india.hp.com>

Hi,

I have Oracle 7.3 DB with its ODBC driver (supplied by Oracle Corp. version 2.00.0301). My application is written using VC++ 4.2 and it writes to the DB using the ODBC calls (apparently it is version 2.1 of ODBC SDK). I have not installed ODBC SDK separately.

My application runs as an NT service and is multithreaded. Everytime a new thread comes in, it creates a new connection to the DB thru' ODBC. As long as I have only one thread, everything is fine. But when I try to have more than one thread, the application behaves erratically and it shuts down sometimes. Can anyone tell me about multithreading with ODBC to connect to Oracle 7.3 in general and what could be the reason for my multithreading to fail ? Is it a problem with the ODBC driver manager as the Oracle driver documentation says that it supports multithreading ?

Thanks,

Raghu Received on Thu Oct 22 1998 - 03:36:27 CDT