Devart Forums

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

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.

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

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).

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

Direct mode does not support load balancing.