Error - DRIVER Keyword Syntax Error {IM012} - Using DG4ODBC and FreeTDS ODBC Driver
(Doc ID 1313099.1)
Last updated on JUNE 08, 2023
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 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.
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
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
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
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
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 |