My Oracle Support Banner

Update or Delete of MySQL or Informix Using DG4ODBC Gives ORA-28500 and Syntax Error Message (Doc ID 1372126.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

A delete or update of MySQL or Informix using 11.2 Database Gateway for ODBC (DG4ODBC) can give the following errors -

delete from "table_events_rec"@dg4odbc where "event_id">730
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[MySQL][ODBC 5.1 Driver][mysqld-5.5.8]You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'A1 WHERE A1.event_id>730' at line 1 {42000,NativeErr =
1064}
ORA-02063: preceding 2 lines from DG4ODBC


or

update "owner"."table_name"@dg4odbc set "sta_chg"=20
where "nuc_chg"=199
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Informix][Informix ODBC Driver][Informix]A syntax error has occurred.
{42000,NativeErr = -201}
ORA-02063: preceding 2 lines from DG4ODBC

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.