My Oracle Support Banner

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 MAY 11, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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=GATESID)))
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.