ODAC and COM+ Neutral Threading Model

zedmartins · Post by **zedmartins** » Tue 24 Jul 2007 17:54

We are trying to implement some COM+ ActiveX Lybraries using Delphi 6 and ODAC components.

Everything works fine if we don't use the Neutral threading model (which is recommended by Microsoft). After changing the threading model and installing the DLLs into COM+ Component Services, the ODAC OraSession component cannot connect to the database anymore and we start getting an ORA-01012 error...

I have a small example project to repeat this error, but I believe I can't attach it here...

Is there anyone who used COM+ Neutral Threading Model and CoreLab ODAC components?

TIA,

Zed

Plash · Post by **Plash** » Wed 25 Jul 2007 09:23

The problem is that OCI cannot work correctly when using the Neutral threading model. If you connect to the database in Direct mode, this problem does not occur. In OCI mode ODAC does not support Neutral threading model.

We have received the same request by e-mail. We replied you to this address but the letter was blocked. Please provide us an alternative e-mail address which we can use to reply to you.

zedmartins · Post by **zedmartins** » Wed 25 Jul 2007 19:13

thanks for your answer. Please try send the message to [email protected] or [email protected].

About the Direct Mode, is there anything to be considered when changing to this?

thanks,

Zed

Plash · Post by **Plash** » Thu 26 Jul 2007 11:45

Direct mode has limitations. There are some of them:
- Some types are not available, like OBJECT, ARRAY, REF, XML, BINARY_DOUBLE, BINARY_FLOAT.
- Multithreaded applications can be less stable when using Direct mode.
See also the list of Direct mode limitations in the ODAC help (the 'Connecting in Direct mode' article).

zedmartins · Post by **zedmartins** » Thu 26 Jul 2007 20:09

is there any chance to use direct mode and oracle load balance?

Plash · Post by **Plash** » Fri 27 Jul 2007 08:03

Direct mode does not support load balancing.