My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.