Error ORA-28500 [ODBC SQL Server Driver] NativeErr = 102 Using SUBSTR From DG4MSQL

(Doc ID 1182280.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

When using SUBSTR operator against a Sql*Server column where the name is 24 characters or more in length then a select using Database Gateway for SQL*Server (DG4MSQL) fails with -


ERROR at line 1:ORA-28500: connection from ORACLE...
[Oracle][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.
 {42000,NativeErr = 102}



The error happens using 11.2 DG4MSQL running on Linux X86-64 and AIX, but not on Linux X86-32 or Windows 32 bit.

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