Re: Connecting to a Database using PRO*C in a multithreading environment

D. Turpin (dominict_at_keops.com) wrote:

: How can one make a connection to a database visible through all
: threads of the application?

: the thing is, if I connect to my database in my main thread and access
: data from there, there's no problem.
 

: BUT
 
: if I try to access the database from ANOTHER thread than the main (a
: child thread), the connection is not visible (and yet it is still
: active in the main)

: is this an unresolvable bug?

Pro*C/C++ for Windows 95, User's Guide, Release 2.1, page 4-10:

"Pro*C/C++ and OCI do not support sharing connections across threads. You must have a separate connection for each thread for accessing the database."

--
John E. Bossom                                     Cognos Inc.
Voice: (613) 738-1338 x3386        O_o             P.O. Box 9707, Stn. T
  FAX: (613) 738-0002             =(  )= Ack!      OTTAWA, ON  K1G 4K9
 INET:  jebossom_at_cognos.COM          U             CANADA