Easysoft.com Documentation Knowledge Base Products  |  Solutions  |  Support  |  Applications  |  Developer  |  Company

---

You may get the following errors when running a query that takes some time to complete (e.g. when fetching a large result set or running select count(*) against a large table):

ORA-02068: following severe error from <link name>
ORA-28511: lost RPC connection to heterogeneous remote agent using

If you turn on HSODBC tracing, the trace output will indicate that:

• There is no problem with the Easysoft driver.
• The data has been returned.
• HSODBC has completed the task successfully.

The problem happens because Oracle times out the link when it takes a long time to get the data from Oracle’s SQL*Net layer to HSODBC.

You may also get these these errors:

ORA-12637: Packet receive failed

ORA-12170: TNS:Connect timeout occurred

ORA-12547: TNS:lost contact

Please see also the related Oracle bugs #6242391 (Oracle 10) and bug #5753490 (accessible from Oracle’s customer support web site.)

When investigating this issue, we resolved the problem by adding this line to the sqlnet.ora file:

SQLNET.INBOUND_CONNECT_TIMEOUT=0

This setting prevents Oracle from timing out the link to HSODBC. Please see the Profile Parameters (sqlnet.ora) in the Oracle Database Net Services Reference Guide for full information on SQLNET.INBOUND_CONNECT_TIMEOUT.

This issue was reported to us by a customer who was using the Easysoft ODBC-SQL Server Driver version 1.2 with Oracle 10.2.0.4 on an AIX platform. It is also a known problem with:

• Oracle 10.2.0.1.0 and 10.2.0.2.0 on Sun Solaris SPARC (64-bit)
• Oracle 10.2.0.3.0 on Linux x86

This issue has not been reported by customers using the Oracle 11g Database Gateway (DG4ODBC).

See Also

• Accessing ODBC and JDBC Data Sources from Oracle Heterogeneous Services (HSODBC)

Applies To

• Products
  • Easysoft ODBC-Oracle Driver
  • Easysoft ODBC-InterBase Driver
  • Easysoft ODBC-ODBC Bridge
  • Easysoft ODBC-Firebird Driver
  • Easysoft ODBC-SQL Server Driver
  • Easysoft ODBC-Oracle WP Driver
  • Easysoft ODBC-Access Driver
• Applications
  • Oracle