Selecting a SQL*Server Float Column Using DG4ODBC Gives Error ORA-28511 (Doc ID 986919.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Jul-2011***


Symptoms


Using DG4ODBC 11.1.0.7 on HP-UX Itanium 11.31 to access SQL*Server 2005 (9.00.3042.00) with Easysoft ODBC for SQL*Server gives an ORA-28511 error when selecting a column with a datatype of FLOAT -
 

SQL> describe dbo.test_float@dg4odbc;

Amount FLOAT(53)
ItemNumber NVARCHAR2(20)


SQL> select "ItemNumber" from dbo.test_float@dg4odbc ;

"ITEMNUMBER"
----------------------------------------
R6450

SQL> select "Amount" from dbo.test_float@dg4odbc ;
select  "Amount" from dbo.test_float@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=TEST.ORACLE.COM)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=TEST.ORACLE.COM)(PORT=1521)))(CON
NECT_DATA=(SERVICE_NAME=DG4ODBC)))
ORA-02063: preceding line from DG4ODBC
Process ID: 2396
Session ID: 3121 Serial number: 23220

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