ODBC - unixODBC

About

unixodbc notes.

Installation

Library

See ODBC - Driver Manager

Environment variable

Library Path

Make sure that ODBCHOME/lib is in the beginning of the libray path environment variable:

  • LD_LIBRARY_PATH for Linux/Solaris
  • LIB_PATH for AIX
  • DYLD_LIBRARY_PATH for mac OS X
  • SHLIB_PATH for HP UX

Location

  • ODBCHOME=odbc-ini-directory
  • ODBCINI=odbc-ini-file See ODBC - ODBC.ini
  • ODBC_INI=odbc-ini-file

Management

odbcinst (odbc installer) is the ODBC Installer and Uninstaller command line tool which can create/remove entries in odbc.ini and odbcinst.ini.

Example of driver and data source installation

See Oracle Database - ODBC Driver Insallation on Linux

Support

Driver's SQLAllocHandle on SQL_HANDLE_HENV

Generally a driver fout. Verify the LD_LIBRARY_PATH

Documentation / Reference

Task Runner