My Oracle Support Banner

Error ORA-28500 [ODBC SQL Server Driver] NativeErr = 102 Using SUBSTR From DG4MSQL (Doc ID 1182280.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.