DG4ODBC Fails With Error Incorrect Syntax using 3rd party ODBC drivers (Doc ID 603662.1)

Last updated on MARCH 04, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
DG4ODBC


Symptoms

Selecting with DataDirect ODBC Driver from a SQL Server table fails with error:

ORA-28500:
[DataDirect][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'SUBQ1'.
ORA-02063:

A DG4ODBC trace shows:

SQL text from hgopars, id=1, len=21 ...
00: 454C4553 2A205443 4F524620 7322204D [SELECT * FROM "s]
10: 31716275 22 [ubq1"]
Entered hgopoer at 2008/06/19-14:10:17
hgopoer, line 159: got native error 170 and sqlstate 42000; message follows...
[DataDirect][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'subq1'.

Changes

Upgrade from HSODBC to DG4ODBC

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