Errors Using DG4ODBC on Windows After Applying Patch 17 or Patch 18 to 11.2.0.3 (Doc ID 1557307.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

After applying any of the following patches to 11.2.0.3 on Windows 32-bit or 64-bit platforms -

16345825 - ORACLE 11G 11.2.0.3 PATCH 17 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64) (Patch)
16345834 - ORACLE 11G 11.2.0.3 PATCH 18 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64) (Patch)

16345824 - ORACLE 11G 11.2.0.3 PATCH 17 BUG FOR WINDOWS 32 BIT (Patch)
16345833 - ORACLE 11G 11.2.0.3 PATCH 18 BUG FOR WINDOWS 32 BIT

The following errors may be returned when using the Database Gateway for ODBC (DG4ODBC) to select from SQL*Server -


SQL> select * from "dbo"."dg4issue" hsmsql_03 ;
  ERROR:
  ORA-28500: connection from ORACLE to a non-Oracle system returned this
  message:
  [Microsoft][ODBC SQL Server Driver]String data, right truncation {01004}
  ORA-02063: preceding 2 lines from HSMSQL_03

 
 

SQL> select * from long_name hsmsql_03 ;
  select * from long_name hsmsql_03
  *
  ERROR at line 1:
  ORA-28500: connection from ORACLE to a non-Oracle system returned this
  message:
  [Microsoft][ODBC SQL Server Driver][SQL
  Server]'TESTING_THIRTY_CHARACTERS_DG4.'
  is an invalid name because it contains a NULL character or an invalid unicode
  character. {42000,NativeErr = 1055}[Microsoft][ODBC SQL Server Driver][SQL
  Server]Statement(s) could not be prepared. {42000,NativeErr = 8180}
  ORA-02063: preceding 2 lines from HSMSQL_03

 

SQL> select * from dual@hsmsql_03 ;
  select * from dual hsmsql_03
               *
  ERROR at line 1:
  ORA-28500: connection from ORACLE to a non-Oracle system returned this
  message:
  [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DUAL'.
  {42S02,NativeErr = 208}[Microsoft][ODBC SQL Server Driver][SQL
  Server]Statement(s) could not be prepared. {42000,NativeErr = 8180}
  ORA-02063: preceding 2 lines from HSMSQL_03

 

The tables on SQL*Server are created using the following scripts -

 



Changes

 Applied Patch 17 or Patch 18 to 11.2.0.3 on Windows platforms.

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