Oracle Database - ODBC Driver Insallation on Linux

/etc/odbcinst.ini where DM-HOME is the data manager home (locate odbcinst

)
* 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
















Discover More
ODBC - unixODBC
unixodbc notes. See Make sure that /lib is in the beginning of the libray path environment variable: LD_LIBRARY_PATH for Linux/Solaris LIB_PATH for AIX DYLD_LIBRARY_PATH...  







Share this page:
     
Follow us: