ODBC

• python library pyodbc
• Linux libraries FreeTDS and unixODBC
• find which files are being used by ODBC - use odbcinst -j
• typical output:

unixODBC 2.3.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

• configure FreeTDS to connect to Sybase ASE - add into both files (DRIVERS, SYSTEM DATA SOURCES):

[FreeTDS]
Description=TDS driver (Sybase/MS SQL)
Driver=libtdsodbc.so
Setup=libtdsS.so
CPTimeout=
CPReuse=
UsageCount=2

• configure in config file:

  connectivity: "odbc"
  odbc:
    driver: 'FreeTDS'