Odbc 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: