Not able to mix up connection types with Oracle provider

[dafe]

Hi,

I was trying to connect to two Oracle databases simultaneously. Everything is working fine until you don’t mix up the connection types. In case you are connecting to the Oracle database through your client (Direct property is set to false) and simultaneously you are trying to connect directly a Oracle database without the client (Direct property is set to true) you will get the following error:

Connection Direct property differs from already active connections

It doesn’t matter if you are connecting to the same or different Oracle database or if you loging in as the same or different user, you just don’t have to mix up the both connection types. Since ODAC is working fine I’m convinced that this is a bug.

Has anybody else reported already this problem? Is there any workaround? We need your help since our product need this functionality and we currently upgraded from ODAC to UniDAC.

Thanks
David

[Plash]

Both ODAC and UniDAC do not allow to have active connections of different types simultaneously. For example, if you have active connections with Direct = False in ODAC and then open a connection with Direct = True, ODAC closes all connections with Direct = False.

UniDAC does not close any connections when you open another connection. You need to close manually all connection with different value of the Direct option before opening a connection.