our team has updated oradirect to version 18.104.22.168 because we wanted to use the direct connetion mode (without using any oracle client).
Now, we've figured out some troubles with expensive sql statements in the direct mode.
If we execute the same query in indirect mode it takes a long time to get the result (which is not that big (less than 50 rows)). But it works fine in this mode.
If we want to do the same query in direct mode, we get an unhandled exception.
Code: Select all
'CoreLab.Oracle.OracleException' in system.data.dll additional information: NET: Network error (System.Net.Sockets.SocketException at System.Net.Sockets.Socket.Receive(Byte buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Net.Sockets.NetworkStream.Read(Byte buffer, Int32 offset, Int32 size)) 'CoreLab.Oracle.OracleException' in corelab.oracle.dll additional information: NET: Network error 200
p.s. changing the "connection timeout" paramter to higher or lower values did't take any effects.