db:oracle:odbc

<DM-HOME>/etc/odbcinst.ini where DM-HOME is the data manager home (locate odbcinst
)
  * and ~/.odbc.ini

=== Drivers ===

Example
  * odbcinst.ini
<code>cat /usr/local/etc/odbcinst.ini</code>
[Oracle 11g ODBC driver]Description     = Oracle ODBC driver for Oracle 11gDriver          = /u01/app/oracle/instantclient_11_2/libsqora.so.11.1Setup           =FileUsage       =CPTimeout       =CPReuse         =


=== DSN ===

  * odbc.ini
<code>cat ~/.odbc.ini</code>
  * Minimal parameters
[Dsn]Driver = /u01/app/oracle/instantclient_12_1/libsqora.so.12.1ServerName = TNS_NAME


  * Complete:

[OracleODBC-11g]Application Attributes = TAttributes = WBatchAutocommitMode = IfAllSuccessfulBindAsFLOAT = FCloseCursor = FDisableDPM = FDisableMTS = TDriver = Oracle 11g ODBC driverDSN = OracleODBC-11gEXECSchemaOpt =EXECSyntax = TFailover = TFailoverDelay = 10FailoverRetryCount = 10FetchBufferSize = 64000ForceWCHAR = FLobs = TLongs = TMaxLargeData = 0MetadataIdDefault = FQueryTimeout = TResultSets = TServerName =SQLGetData extensions = FTranslation DLL =Translation Option = 0DisableRULEHint = TUserID =StatementCache=FCacheBufferSize=20UseOCIDescribeAny=F



==== Test it ====
with unixODBC - isql
<code>isql -v OracleODBC-11g</code>

===== Support =====
==== undefined symbol: SQLGetPrivateProfileStringW ====

You may get the following:
isql: symbol lookup error: /u01/app/oracle/instantclient_11_2/libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW



This is normally because the driver manager (unixODBC) version is not compatible with the ODBC driver. Verify the #driver manager version needed for the oracle ODBC database version.











See below how to search for a symbol:
  * Symbol lookup
<code>nm -A /u01/app/oracle/instantclient_11_2/libsqora.so.11.1 | grep SQLGetPrivateProfileStringW</code>
/u01/app/oracle/instantclient_11_2/libsqora.so.11.1:                U SQLGetPrivateProfileStringW



SQLGetPrivateProfileStringW is defined in the last libodbc.so and libodbcinst.so.

<code>nm -A /usr/lib/libodbcinst.so | grep SQLGetPrivateProfileStringW</code>
Blank




===== Documentation / Reference =====
  * Installation Guide
  * mkleehammer/pyodbc/wiki/Connecting-to-Oracle-from-RHEL-or-Centos
  * http://stackoverflow.com/questions/13922415/how-do-i-setup-oracle-odbc-drivers-on-rhel-6-linux