Skip to content

Instantly share code, notes, and snippets.

@ederrafo
Last active January 24, 2020 05:10
Show Gist options
  • Select an option

  • Save ederrafo/a8ced1baf20e4ad5d9260d47e72e3c02 to your computer and use it in GitHub Desktop.

Select an option

Save ederrafo/a8ced1baf20e4ad5d9260d47e72e3c02 to your computer and use it in GitHub Desktop.
unixodbc odbc

unixodbc

Primero instalar el unixodbc la version 2.2.14, que es compratible con las versiones instaladas desde los repositorios de ubuntu (apt-get install php7 tdsodbc)

unixodbc 2.2.14

$ unzip unixODBC-2.3.4.zip
$ wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.2.14.tar.gz
Modified the source, after build compile and install
$ ./configure --prefix=/usr --sysconfdir=/etc --libdir=/usr/lib/x86_64-linux-gnu/ --includedir=/usr/lib/x86_64-linux-gnu/ --includedir=/usr/include --sbindir=/sbin --bindir=/bin --enable-gui=no && make && sudo make install
vagrant@vagrant-ubuntu-trusty-64:/$ sudo git status
On branch master
Changes not staged for commit:
  (use "git add <file>..." to update what will be committed)
  (use "git checkout -- <file>..." to discard changes in working directory)

        modified:   usr/include/unixodbc_conf.h
        typechange: usr/lib/x86_64-linux-gnu/libgtrtst.so.1
        modified:   usr/lib/x86_64-linux-gnu/libgtrtst.so.1.0.0
        typechange: usr/lib/x86_64-linux-gnu/libodbc.so.1
        modified:   usr/lib/x86_64-linux-gnu/libodbc.so.1.0.0
        typechange: usr/lib/x86_64-linux-gnu/libodbccr.so.1
        modified:   usr/lib/x86_64-linux-gnu/libodbccr.so.1.0.0

Untracked files:
  (use "git add <file>..." to include in what will be committed)

        bin/dltest
        bin/isql
        bin/iusql
        bin/odbc_config
        bin/odbcinst
        usr/include/autotest.h
        usr/include/odbcinst.h
        usr/include/odbcinstext.h
        usr/include/sql.h
        usr/include/sqlext.h
        usr/include/sqltypes.h
        usr/include/sqlucode.h
        usr/include/uodbc_extras.h
        usr/include/uodbc_stats.h
        usr/lib/x86_64-linux-gnu/libboundparam.la
        usr/lib/x86_64-linux-gnu/libboundparam.so
        usr/lib/x86_64-linux-gnu/libboundparam.so.1
        usr/lib/x86_64-linux-gnu/libboundparam.so.1.0.0
        usr/lib/x86_64-linux-gnu/libesoobS.la
        usr/lib/x86_64-linux-gnu/libesoobS.so
        usr/lib/x86_64-linux-gnu/libesoobS.so.1
        usr/lib/x86_64-linux-gnu/libesoobS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libgtrtst.la
        usr/lib/x86_64-linux-gnu/libgtrtst.so
        usr/lib/x86_64-linux-gnu/libmimerS.la
        usr/lib/x86_64-linux-gnu/libmimerS.so
        usr/lib/x86_64-linux-gnu/libmimerS.so.1
        usr/lib/x86_64-linux-gnu/libmimerS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libnn.la
        usr/lib/x86_64-linux-gnu/libnn.so
        usr/lib/x86_64-linux-gnu/libnn.so.1
        usr/lib/x86_64-linux-gnu/libnn.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbc.la
        usr/lib/x86_64-linux-gnu/libodbc.so
        usr/lib/x86_64-linux-gnu/libodbccr.la
        usr/lib/x86_64-linux-gnu/libodbccr.so
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg1S.la
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg1S.so
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg1S.so.1
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg1S.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg2S.la
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg2S.so
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg2S.so.1
        usr/lib/x86_64-linux-gnu/libodbcdrvcfg2S.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbcinst.la
        usr/lib/x86_64-linux-gnu/libodbcinst.so
        usr/lib/x86_64-linux-gnu/libodbcinst.so.1
        usr/lib/x86_64-linux-gnu/libodbcinst.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbcminiS.la
        usr/lib/x86_64-linux-gnu/libodbcminiS.so
        usr/lib/x86_64-linux-gnu/libodbcminiS.so.1
        usr/lib/x86_64-linux-gnu/libodbcminiS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbcmyS.la
        usr/lib/x86_64-linux-gnu/libodbcmyS.so
        usr/lib/x86_64-linux-gnu/libodbcmyS.so.1
        usr/lib/x86_64-linux-gnu/libodbcmyS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbcnnS.la
        usr/lib/x86_64-linux-gnu/libodbcnnS.so
        usr/lib/x86_64-linux-gnu/libodbcnnS.so.1
        usr/lib/x86_64-linux-gnu/libodbcnnS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbcpsql.la
        usr/lib/x86_64-linux-gnu/libodbcpsql.so
        usr/lib/x86_64-linux-gnu/libodbcpsql.so.1
        usr/lib/x86_64-linux-gnu/libodbcpsql.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbcpsql.so.2
        usr/lib/x86_64-linux-gnu/libodbcpsql.so.2.0.0
        usr/lib/x86_64-linux-gnu/libodbcpsqlS.la
        usr/lib/x86_64-linux-gnu/libodbcpsqlS.so
        usr/lib/x86_64-linux-gnu/libodbcpsqlS.so.1
        usr/lib/x86_64-linux-gnu/libodbcpsqlS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libodbctxtS.la
        usr/lib/x86_64-linux-gnu/libodbctxtS.so
        usr/lib/x86_64-linux-gnu/libodbctxtS.so.1
        usr/lib/x86_64-linux-gnu/libodbctxtS.so.1.0.0
        usr/lib/x86_64-linux-gnu/liboplodbcS.la
        usr/lib/x86_64-linux-gnu/liboplodbcS.so
        usr/lib/x86_64-linux-gnu/liboplodbcS.so.1
        usr/lib/x86_64-linux-gnu/liboplodbcS.so.1.0.0
        usr/lib/x86_64-linux-gnu/liboraodbcS.la
        usr/lib/x86_64-linux-gnu/liboraodbcS.so
        usr/lib/x86_64-linux-gnu/liboraodbcS.so.1
        usr/lib/x86_64-linux-gnu/liboraodbcS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libsapdbS.la
        usr/lib/x86_64-linux-gnu/libsapdbS.so
        usr/lib/x86_64-linux-gnu/libsapdbS.so.1
        usr/lib/x86_64-linux-gnu/libsapdbS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libtdsS.la
        usr/lib/x86_64-linux-gnu/libtdsS.so
        usr/lib/x86_64-linux-gnu/libtdsS.so.1
        usr/lib/x86_64-linux-gnu/libtdsS.so.1.0.0
        usr/lib/x86_64-linux-gnu/libtemplate.la
        usr/lib/x86_64-linux-gnu/libtemplate.so
        usr/lib/x86_64-linux-gnu/libtemplate.so.1
        usr/lib/x86_64-linux-gnu/libtemplate.so.1.0.0

Fijarse se la libreria tds es cargable y que dependencias tiene

$ ldd /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so

Instalar tdsodbc

$ sudo apt-get install tdsodbc
  modified:   etc/ld.so.cache
        typechange: usr/lib/x86_64-linux-gnu/libodbcinst.so.1
        modified:   usr/lib/x86_64-linux-gnu/libodbcinst.so.1.0.0

Untracked files:
  (use "git add <file>..." to include in what will be committed)

        usr/bin/odbcinst
        usr/lib/x86_64-linux-gnu/odbc/libesoobS.so
        usr/lib/x86_64-linux-gnu/odbc/libmimerS.so
        usr/lib/x86_64-linux-gnu/odbc/libodbcdrvcfg1S.so
        usr/lib/x86_64-linux-gnu/odbc/libodbcdrvcfg2S.so
        usr/lib/x86_64-linux-gnu/odbc/libodbcminiS.so
        usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
        usr/lib/x86_64-linux-gnu/odbc/libodbcnnS.so
        usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
        usr/lib/x86_64-linux-gnu/odbc/libodbctxtS.so
        usr/lib/x86_64-linux-gnu/odbc/liboplodbcS.so
        usr/lib/x86_64-linux-gnu/odbc/liboraodbcS.so
        usr/lib/x86_64-linux-gnu/odbc/libsapdbS.so
        usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
        usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
        usr/share/doc/odbcinst/
        usr/share/doc/odbcinst1debian2/
        usr/share/doc/tdsodbc/
        usr/share/lintian/overrides/odbcinst1debian2
        usr/share/man/man1/odbcinst.1.gz
        usr/share/tdsodbc/

-- apt-get install php7.0-odbc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment