URGENT: New connection to database using the direct (NET) method closes main connection using BDESession

[pmatos]

Hi!

We have an application that for any number of reasons still uses BDESession and BDE to connect to the database (ORA8i).

So, we have someting like ORA BDESession APP

On a new module, it's required connection to remote databases using only the direct (NET) method.

So, I create a new connection using TOraSession, but when changing the options to NET the main connection (using bde/bdesession) closes, when it should remain open.

-- sample of the new code --

Self.FcnORCL := TOraSession.Create(nil);
Self.FcnORCL.Options.Net := True; <-- main db connection closes when executing this
Self.FcnORCL.Options.NeverConnect := True;


--- end sample ---

There's any way to solve/workaround this without having to change the old code?

Thanks!

[Plash]

We cannot reproduce the problem. If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

[Plash]

We have reproduced the problem. This is designed behavior.
ODAC doesn't allow to have direct connections with Net option and connections using OCI at the same time.