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 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

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


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