Direct Mode does not supply domain name in V$SESSION.MACHINE column

[Apparel21]

Hi everyone,

In our applications we typically use a non-direct method of connecting, and the MACHINE column of V$SESSION is correctly populated with the domain and terminal, as below:

Code: Select all

var oracleConnection1 = new OracleConnection();
oracleConnection1.Direct = false;
oracleConnection1.Server = "DEV";
oracleConnection1.UserId = "MYSCHEMA";
oracleConnection1.Password = "xxx";

MACHINE = 'MYDOMAIN\MYLAPTOP'

However when I use Direct Mode the MACHINE column just has the terminal name:

Code: Select all

oracleConnection2.Direct = true;
oracleConnection2.Server = "Server01";
oracleConnection2.Port = 1521;
oracleConnection2.Sid = "DEV";
oracleConnection2.UserId = "MYSCHEMA";
oracleConnection2.Password = "xxx";
oracleConnection2.Open();

MACHINE = 'MYLAPTOP'

Additionally, I also noticed that the process was 00000:00000.

We are unable to use the non-direct mode in this particular case, but we rely on the values in the MACHINE column for other processes.

Does anyone know any workarounds or fixes? We're running C# against Devart.Data.Oracle.dll v 8.5.602.0.

Thanks,
Jonathan

[Pinturiccio]

Currently this is a normal behavior, and dotConnect for Oracle does not support output of the domain to the "machine" column and output of the "process" column values in the Direct mode. We will investigate the possibility to support domains for the "machine" column and values for the "process" column in the Direct mode and post here about the results as soon as possible.

[Apparel21]

Thanks for the quick reply! I look forward to hearing how it goes.

[Apparel21]

Hi again,

Any news on whether this will be modified or not?

Cheers,
Jonathan

[Pinturiccio]

We are investigating the issue and will notify you about the result as soon as possible, but we can't tell any timeframe at the moment.

[Pinturiccio]

We have supported the output of the domain to the "machine" column and output of the "process" column values in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

[Pinturiccio]

New build of dotConnect for Oracle 9.1.121 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34384

[Apparel21]

Fantastic, thanks for the update!