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 laterInformation 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}
[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 |