Devart Forums

I have main form with session and MDI-child forms with child session
In design time Options.Net=True for all sessions (main and child)
In runtime Options.Net=False for main session
Then create child form, params of main session (connect string and Net) assign to child session
Then create child form, all existent sessions (main and child) are closed.

P.S. I send mail with test project to support

ODAC doesn't support two modes (Net and native) simultaneously, in previous ODAC versions if you change Net option state then all sessions in IDE change their Net state too, now we change this behaviour and you can set a different state of Net option to TOraSession objects, but it doesn't mean that you can use "Net" and "native" modes simultaneously. The feature to use different state of Net option at design-time was added for those users who want to load several projects in IDE, where some projects use Net option and the other don't.

But why it occurs in runtime? I think, if first created session nas Net=True, then ODAC engine must set Net to True for all next created sessions without closing prveviously created and opened sessions , and vice versa.

As to run-time created sessions you are right, and I can see such behaviour on my test samples. Maybe you have some exotical case, so please send us small demo project that demonstrates your problem to ODAC support address.

I send demo project

I couldn't reproduce the problem with your demo, please specify your ODAC version.

Delphi 6
ODAC 5.55.0.19

I reproduced your problem with MDI application and different Net option settings.
The main cause of such ODAC behaviour is that it can't use Net and native connections simultaneously. When you create a new MDI child form, you implicitly create new NET session, so not all Net sessions are disconnected - that is your problem. As a decision of this problem I could suggest you to create MDI Child sessions at run-time.