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 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Jul-2011***


Using DG4ODBC 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 ;


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
ORA-02063: preceding line from DG4ODBC
Process ID: 2396
Session ID: 3121 Serial number: 23220


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