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

Last updated on JANUARY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 26-NOV-2013***

Symptoms

 
A select using Database Gateway for ODBC (DG4ODBC) 11.2.0.1 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


and an ODBC trace shows -


[ODBC][9497][SQLDriverConnect.c][678]
Entry:
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

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