)
* and ~/.odbc.ini
=== Drivers ===
Example
* odbcinst.ini
cat /usr/local/etc/odbcinst.ini
[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
cat ~/.odbc.ini
* 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
isql -v OracleODBC-11g
===== 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
nm -A /u01/app/oracle/instantclient_11_2/libsqora.so.11.1 | grep SQLGetPrivateProfileStringW
/u01/app/oracle/instantclient_11_2/libsqora.so.11.1: U SQLGetPrivateProfileStringW
SQLGetPrivateProfileStringW is defined in the last libodbc.so and libodbcinst.so.
nm -A /usr/lib/libodbcinst.so | grep SQLGetPrivateProfileStringW
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