Devart Forums

sumit

Hi,

We are trying to optimize our application that uses CoreLab oradirect.net 3.55.16 drivers to connect to Oracle database using direct connection (clientless) mode.

On the server side, we changed the listener.ora file to set the SDU to 8192 bytes using the following syntax:

Code: Select all

    (SID_DESC =
      (GLOBAL_DBNAME = falconda)
      (SDU=8192)
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = falconda)
    )

In the absense of tnsnames.ora file (not required for a direct connection mode), how to we specify this information in the connectionstring. If we had a tnsnames.ora file on the application server, we could have used something like this:

Code: Select all

FALCONDA =
  (DESCRIPTION =
  (SDU=8192)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = newyork)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = falconda)
    )
  )

sumit

Hi Alexey,

Irfan is not available for few weeks so I am following up on the issue.

The problem still exists with the latest version of the drivers. If however, I change
myLob = new OracleLob(this._connection as OracleConnection, OracleDbType.Blob);

to

myLob = new OracleLob(this._connection as OracleConnection, OracleDbType.Clob);

, I do not get garbage data but instead the data gets truncated in Oracle 10g Unicode = True and in Oracle 9i Unicode = True, I get ORA-06505 error.

If I do not make this change,
Oracle 9i (Unicode) works and Oracle 10g (Unicode) gives me junk characters even in the latest drivers.

I have a sample project that connects to 10g (Unicode) where the string gets truncated. Please let me know how to send you the sample project.

Any help will be appreciated. Thanks!

Devart Forums

Search found 62 matches

How to specify SDU (session data unit) size in direct connection mode connectionstring

Problem still exists...