Re: ODBC & Multithreading ...

Raghu,

Old versions of the ODBC driver manager were not thread safe. If my memory is reliable, the first version of the ODBC driver manager that was thread safe was the 2.5 version.

You might try downloading the Microsoft ODBC sdk, which comes with an threadsafe Oracle driver and driver manager.

Hope this helps

         candi

In article <362EEE8B.A975DA0D_at_india.hp.com>,   "K. Raghuraman" <kraghu_at_india.hp.com> wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 14:44:02 CDT