Page 1 of 1

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

Posted: Mon 31 Jul 2006 13:09
by 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!

Posted: Tue 01 Aug 2006 07:47
by 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.

Posted: Tue 01 Aug 2006 09:53
by 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.