DG4ODBC ORA-28511 with NativeErr 5703 and 5701 and SQLSTATE 01000 Using EasySoft ODBC Driver For MS SQL Server On Unix Platforms (Doc ID 1527574.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Generic UNIX

Symptoms

After an upgrade of the Database Gateway for ODBC (DG4ODBC) to 11.2 from  a 11.1 version using the Easysoft ODBC driver to connect to MS SQL Server, statements fail with an error ORA-28511 -

SQL> select count(*) from "My_Table"@DG4ODBC;
select count(*) from "My_Table"@DG4ODBC
  *
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver)(PORT=1523)
))(CONNECT_DATA=(SID=RISKART)))
ORA-02063: preceding line from DG4ODBC
Process ID: 23560
Session ID: 130 Serial number: 181

 

 

A Gateway trace file hangs :

 

which is coming from the ODBC connection.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms