Devart Forums

Hello,

Is it possible to use both NET = True and NET = False TOraSessions in a single application?

From testing, it seems that if one is connected, it will disconnect the other session if the NET option is different.

I'm using the .15 build - I can see the .16 build having this fix:
* Different state of Net option at design-time supported

Would that have anything to do with this?

--
Martijn Tonies
Upscene Productions

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 different state of NET option to TOraSession objects, but it doesn't mean that you can use "Net" and "native" modes simultaneously.
This feature 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 it doesn't mean that you can use "Net" and "native" modes simultaneously

Not even for two different TOraSessions?

Why can this not be done?

--
Martijn Tonies
Upscene Productions

There is no such necessity in ODAC to support two modes simultaneously. In situation when customer has Oracle client installed on his PC he prefer to use "native" mode which give better opportunity to work with Oracle, and if he hasn't then he use "Net" mode and can't use "native" mode at all.

well, during my particular test, I was connected (via TNS names) with two sessions, while I also attempted a non-tns-registered session. This failed.

Hence, the requirement for having both

From my application, you have two ways of connecting, via TNS or "direct". The direct connections are much faster, but I can surely understand the need for using both in the same application at the same time.

I would certainly appreciate it if this would be possible.

--
Martijn Tonies
Upscene Productions