Errors Using DG4ODBC on Windows After Applying Patch 17 or Patch 18 to 11.2.0.3
(Doc ID 1557307.1)
Last updated on SEPTEMBER 20, 2021
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 -
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
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
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 |