My Oracle Support Banner

Error - DRIVER Keyword Syntax Error {IM012} - Using DG4ODBC and FreeTDS ODBC Driver (Doc ID 1313099.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


A select using Database Gateway for ODBC (DG4ODBC) on Linux x86-64 with the FreeTDS 0.83 ODBC driver to SQL*Server gives the error -

SQL> select count(1) from sys.All_users@dblink;
select count(1) from sys.All_users@dblink
ERRO na linha 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][Driver Manager]DRIVER keyword syntax error {IM012}
ORA-02063: preceding 2 lines from DBLINK

An ISQL connection using the same driver to SQL*Server is successful.
A DG4ODBC debug trace shows the error -

Entered hgopoer at 2011/04/06-18:21:30
hgopoer, line 233: got native error 0 and sqlstate IM012; message follows...
[unixODBC][Driver Manager]DRIVER keyword syntax error {IM012}
Exiting hgopoer, rc=0 at 2011/04/06-18:21:30

and an ODBC trace shows -

Connection = 0x10fc7dc0
Window Hdl = (nil)
Str In = [DSN=10.XXX.XX.XXX:1433//MSQLDATABASE;UID=xx_user;PWD=***********][length = 65]
Str Out = 0x10fc9e88
Str Out Max = 1024
Str Out Ptr = 0x7fffba4d1400
Completion = 0
[ODBC][9497][SQLDriverConnect.c][1064]Error: IM012


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.