How To Install unixODBC on CentOS 8
unixODBC is A complete ODBC driver manager for Linux A complete ODBC driver manager for Linux
Introduction
In this tutorial we learn how to install unixODBC on CentOS 8.
What is unixODBC
Install unixODBC if you want to access databases through ODBC. You will also need the mariadb-connector-odbc package if you want to access a MySQL or MariaDB database, and/or the postgresql-odbc package for PostgreSQL. unixODBC 2.3.7 1.el8 x86_64 458 k unixODBC-2.3.7-1.el8.src.rpm appstream A complete ODBC driver manager for Linux http GPLv2+ and LGPLv2+ Install unixODBC if you want to access databases through ODBC. You will also need the mariadb-connector-odbc package if you want to access a MySQL or MariaDB database, and/or the postgresql-odbc package for PostgreSQL.
We can use yum or dnf to install unixODBC on CentOS 8. In this tutorial we discuss both methods but you only need to choose one of method to install unixODBC.
Install unixODBC on CentOS 8 Using dnf
Update yum database with dnf using the following command.
sudo dnf makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 kB 00:00
Metadata cache created.
After updating yum database, We can install unixODBC using dnf by running the following command:
sudo dnf -y install unixODBC
Install unixODBC on CentOS 8 Using yum
Update yum database with yum using the following command.
sudo yum makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 kB 00:00
Metadata cache created.
After updating yum database, We can install unixODBC using yum by running the following command:
sudo yum -y install unixODBC
How To Uninstall unixODBC on CentOS 8
To uninstall only the unixODBC package we can use the following command:
sudo dnf remove unixODBC
unixODBC Package Contents on CentOS 8
/etc/odbc.ini
/etc/odbcinst.ini
/usr/bin/dltest
/usr/bin/isql
/usr/bin/iusql
/usr/bin/odbc_config
/usr/bin/odbcinst
/usr/bin/slencheck
/usr/lib/.build-id
/usr/lib/.build-id/04
/usr/lib/.build-id/04/586a96194363792b45e601805f9f7cc9bf672a
/usr/lib/.build-id/14
/usr/lib/.build-id/14/469996556f474eed4780782883b00c967b6833
/usr/lib/.build-id/15
/usr/lib/.build-id/15/2df5e68ce9e4735e625bbcd9432becac097991
/usr/lib/.build-id/15/a5727f8089b1f2fd7b3237cd6b98c3f477a1f3
/usr/lib/.build-id/38
/usr/lib/.build-id/38/d422a01159b90281e35e5c0a8e68bfce255afc
/usr/lib/.build-id/43
/usr/lib/.build-id/43/a8fe0cf6c7965618c06eb329fc2c5fa968c99e
/usr/lib/.build-id/73
/usr/lib/.build-id/73/14ffdcad282a847e6436241f3415509adceea0
/usr/lib/.build-id/75
/usr/lib/.build-id/75/1740af7be4e008e2314688b972b509328887a7
/usr/lib/.build-id/7a
/usr/lib/.build-id/7a/1f6269b2c643fd9f443a0693050df947478660
/usr/lib/.build-id/7c
/usr/lib/.build-id/7c/10175e594d530bea5dad75e1e8d3a77c355981
/usr/lib/.build-id/7d
/usr/lib/.build-id/7d/12207b4fa9e2abafe8838b7882713c06f038c2
/usr/lib/.build-id/85
/usr/lib/.build-id/85/3d0aaf7f254bf651dba507fc4551052ba6cc7d
/usr/lib/.build-id/98
/usr/lib/.build-id/98/d73a175b84ab869bfc10460aefb33d2d8b088e
/usr/lib/.build-id/9c
/usr/lib/.build-id/9c/1e2bf2488661c63f1313090d69479c283c79a8
/usr/lib/.build-id/9f
/usr/lib/.build-id/9f/2064005a4f3e81005ff4942b601a6118e61ead
/usr/lib/.build-id/a3
/usr/lib/.build-id/a3/ed845ec871fff19fa4ce066091d1fea4867fc9
/usr/lib/.build-id/a5
/usr/lib/.build-id/a5/77de224eaa14f7c33c7a666aad1fa146e32d1a
/usr/lib/.build-id/b9
/usr/lib/.build-id/b9/83a142949e68a394ec47bf972aa3d815f72b3f
/usr/lib/.build-id/bc
/usr/lib/.build-id/bc/b1276ebe415e0060227954fd8d23af244cf66c
/usr/lib/.build-id/be
/usr/lib/.build-id/be/8c0242953c09bd0f3be5c9f11bef27e7e23516
/usr/lib/.build-id/c4
/usr/lib/.build-id/c4/d05a232ee95f078bf314683d9ce40a40cce005
/usr/lib/.build-id/e2
/usr/lib/.build-id/e2/ac950a44fbdb2f5bbda57655d6c31020a9ce12
/usr/lib/.build-id/ea
/usr/lib/.build-id/ea/2fa30cd54fdc6c92131863a8e7f3847033779c
/usr/lib/.build-id/f6
/usr/lib/.build-id/f6/db6efc9f5d24fc0534aa0f8c1ccf527f89241a
/usr/lib64/libesoobS.so.2
/usr/lib64/libesoobS.so.2.0.0
/usr/lib64/libmimerS.so.2
/usr/lib64/libmimerS.so.2.0.0
/usr/lib64/libnn.so.2
/usr/lib64/libnn.so.2.0.0
/usr/lib64/libodbc.so
/usr/lib64/libodbc.so.2
/usr/lib64/libodbc.so.2.0.0
/usr/lib64/libodbccr.so.2
/usr/lib64/libodbccr.so.2.0.0
/usr/lib64/libodbcdrvcfg1S.so.2
/usr/lib64/libodbcdrvcfg1S.so.2.0.0
/usr/lib64/libodbcdrvcfg2S.so.2
/usr/lib64/libodbcdrvcfg2S.so.2.0.0
/usr/lib64/libodbcinst.so
/usr/lib64/libodbcinst.so.2
/usr/lib64/libodbcinst.so.2.0.0
/usr/lib64/libodbcminiS.so.2
/usr/lib64/libodbcminiS.so.2.0.0
/usr/lib64/libodbcmyS.so
/usr/lib64/libodbcmyS.so.2
/usr/lib64/libodbcmyS.so.2.0.0
/usr/lib64/libodbcnnS.so.2
/usr/lib64/libodbcnnS.so.2.0.0
/usr/lib64/libodbcpsqlS.so
/usr/lib64/libodbcpsqlS.so.2
/usr/lib64/libodbcpsqlS.so.2.0.0
/usr/lib64/libodbctxtS.so.2
/usr/lib64/libodbctxtS.so.2.0.0
/usr/lib64/liboplodbcS.so.2
/usr/lib64/liboplodbcS.so.2.0.0
/usr/lib64/liboraodbcS.so.2
/usr/lib64/liboraodbcS.so.2.0.0
/usr/lib64/libsapdbS.so.2
/usr/lib64/libsapdbS.so.2.0.0
/usr/lib64/libtdsS.so
/usr/lib64/libtdsS.so.2
/usr/lib64/libtdsS.so.2.0.0
/usr/lib64/libtemplate.so.2
/usr/lib64/libtemplate.so.2.0.0
/usr/share/doc/unixODBC
/usr/share/doc/unixODBC/AUTHORS
/usr/share/doc/unixODBC/COPYING
/usr/share/doc/unixODBC/ChangeLog
/usr/share/doc/unixODBC/NEWS
/usr/share/doc/unixODBC/README
/usr/share/doc/unixODBC/README.dist
/usr/share/doc/unixODBC/doc
/usr/share/doc/unixODBC/doc/AdministratorManual
/usr/share/doc/unixODBC/doc/AdministratorManual/index.html
/usr/share/doc/unixODBC/doc/AdministratorManual/odbcinst.html
/usr/share/doc/unixODBC/doc/AdministratorManual/php3.html
/usr/share/doc/unixODBC/doc/AdministratorManual/unixODBC.gif
/usr/share/doc/unixODBC/doc/AdministratorManual/unixODBCsetup.html
/usr/share/doc/unixODBC/doc/ProgrammerManual
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/close.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/conne.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/dsn.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/gloss.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/index.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/intro.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/navi.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/odbc.css
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/query.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/resul.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/index.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/unixODBC.gif
/usr/share/doc/unixODBC/doc/UserManual
/usr/share/doc/unixODBC/doc/UserManual/Figure1.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure2.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure3.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure4.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure6.gif
/usr/share/doc/unixODBC/doc/UserManual/My.sql
/usr/share/doc/unixODBC/doc/UserManual/StarOfficeDataGrid.gif
/usr/share/doc/unixODBC/doc/UserManual/index.html
/usr/share/doc/unixODBC/doc/UserManual/unixODBC.gif
/usr/share/doc/unixODBC/doc/index.html
/usr/share/doc/unixODBC/doc/lst
/usr/share/doc/unixODBC/doc/lst/InternalStructure.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure.vsd
/usr/share/doc/unixODBC/doc/lst/InternalStructure2.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure2.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure3.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure3.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure4.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure4.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure5.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure5.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure6.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure6.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure7.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure7.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure8.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure8.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure9.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure9.html
/usr/share/doc/unixODBC/doc/lst/back.gif
/usr/share/doc/unixODBC/doc/lst/next.gif
/usr/share/doc/unixODBC/doc/smallbook.gif
/usr/share/doc/unixODBC/doc/unixODBC.gif
/usr/share/man/man1/dltest.1.gz
/usr/share/man/man1/isql.1.gz
/usr/share/man/man1/iusql.1.gz
/usr/share/man/man1/odbc_config.1.gz
/usr/share/man/man1/odbcinst.1.gz
/usr/share/man/man5/odbc.ini.5.gz
/usr/share/man/man5/odbcinst.ini.5.gz
/usr/share/man/man7/unixODBC.7.gz
/etc/odbc.ini
/etc/odbcinst.ini
/usr/bin/dltest
/usr/bin/isql
/usr/bin/iusql
/usr/bin/odbc_config
/usr/bin/odbcinst
/usr/bin/slencheck
/usr/lib/.build-id
/usr/lib/.build-id/0b
/usr/lib/.build-id/0b/3518330ca452fee7ec8dfd1c608721bd86413d
/usr/lib/.build-id/1d
/usr/lib/.build-id/1d/f5e73545abdf84f94188f3cf1c0416d9220359
/usr/lib/.build-id/34
/usr/lib/.build-id/34/8579c499a5c7ea01c221729f0c9e2246b708ba
/usr/lib/.build-id/52
/usr/lib/.build-id/52/271bd73ebdf9b3e0e3c9ba8ce3ca02653f755c
/usr/lib/.build-id/5a
/usr/lib/.build-id/5a/e883f821bacbaf9969b2477b108078f19274af
/usr/lib/.build-id/5f
/usr/lib/.build-id/5f/071bb62e66e332a72b5969f85987f1355f7c9a
/usr/lib/.build-id/68
/usr/lib/.build-id/68/6e9eaad4ed4a7c5eccb5728785d6fe4dcd1022
/usr/lib/.build-id/70
/usr/lib/.build-id/70/e8d1afff2771f58c477ca8be5483d25e65d392
/usr/lib/.build-id/7d
/usr/lib/.build-id/7d/b6e3c35de14e5943c2a866c293214825acd024
/usr/lib/.build-id/94
/usr/lib/.build-id/94/7b826f39bc5bbdae27741b41bd022aa40b4b06
/usr/lib/.build-id/98
/usr/lib/.build-id/98/19e3eea9e26a26dc41b26253d8c78e28650971
/usr/lib/.build-id/a0
/usr/lib/.build-id/a0/32a62404bdc38b7a20e7fbc041dac99889af37
/usr/lib/.build-id/a0/44e29a222ff54e43dd00510f46f7aac0ebacce
/usr/lib/.build-id/ae
/usr/lib/.build-id/ae/ac111dcd6fb425b02736c1a829b7f506be89a4
/usr/lib/.build-id/b3
/usr/lib/.build-id/b3/8afcd80b8bdc52f8b576d7f1b5255e91d459e3
/usr/lib/.build-id/c7
/usr/lib/.build-id/c7/13c94b421f614da29da6b08380e3b3d6b3e532
/usr/lib/.build-id/cc
/usr/lib/.build-id/cc/061620f821578e9d7ef05bdc4d8c4b3b4531ad
/usr/lib/.build-id/d2
/usr/lib/.build-id/d2/3dd31e161c6068edaec6d5cdcc7d97fcc0bf3f
/usr/lib/.build-id/db
/usr/lib/.build-id/db/5619242013cc1a2edba9fc5449520a43b2b1bc
/usr/lib/.build-id/e0
/usr/lib/.build-id/e0/fa7a16a2d4f033e6df69a718774ba29041d320
/usr/lib/.build-id/e1
/usr/lib/.build-id/e1/016a46fb3df36dcc5b7c786bfd8646939077b2
/usr/lib/.build-id/e4
/usr/lib/.build-id/e4/03725dcdba01235c3164ecf59154dfe1f56667
/usr/lib/.build-id/f0
/usr/lib/.build-id/f0/56b9ffd5e02f55e92754ac5b78277042a6e8bb
/usr/lib/.build-id/f7
/usr/lib/.build-id/f7/f8e8d12a0b89f376f6adb3a8f43ddb511f5e3e
/usr/lib/libesoobS.so.2
/usr/lib/libesoobS.so.2.0.0
/usr/lib/libmimerS.so.2
/usr/lib/libmimerS.so.2.0.0
/usr/lib/libnn.so.2
/usr/lib/libnn.so.2.0.0
/usr/lib/libodbc.so
/usr/lib/libodbc.so.2
/usr/lib/libodbc.so.2.0.0
/usr/lib/libodbccr.so.2
/usr/lib/libodbccr.so.2.0.0
/usr/lib/libodbcdrvcfg1S.so.2
/usr/lib/libodbcdrvcfg1S.so.2.0.0
/usr/lib/libodbcdrvcfg2S.so.2
/usr/lib/libodbcdrvcfg2S.so.2.0.0
/usr/lib/libodbcinst.so
/usr/lib/libodbcinst.so.2
/usr/lib/libodbcinst.so.2.0.0
/usr/lib/libodbcminiS.so.2
/usr/lib/libodbcminiS.so.2.0.0
/usr/lib/libodbcmyS.so
/usr/lib/libodbcmyS.so.2
/usr/lib/libodbcmyS.so.2.0.0
/usr/lib/libodbcnnS.so.2
/usr/lib/libodbcnnS.so.2.0.0
/usr/lib/libodbcpsqlS.so
/usr/lib/libodbcpsqlS.so.2
/usr/lib/libodbcpsqlS.so.2.0.0
/usr/lib/libodbctxtS.so.2
/usr/lib/libodbctxtS.so.2.0.0
/usr/lib/liboplodbcS.so.2
/usr/lib/liboplodbcS.so.2.0.0
/usr/lib/liboraodbcS.so.2
/usr/lib/liboraodbcS.so.2.0.0
/usr/lib/libsapdbS.so.2
/usr/lib/libsapdbS.so.2.0.0
/usr/lib/libtdsS.so
/usr/lib/libtdsS.so.2
/usr/lib/libtdsS.so.2.0.0
/usr/lib/libtemplate.so.2
/usr/lib/libtemplate.so.2.0.0
/usr/share/doc/unixODBC
/usr/share/doc/unixODBC/AUTHORS
/usr/share/doc/unixODBC/COPYING
/usr/share/doc/unixODBC/ChangeLog
/usr/share/doc/unixODBC/NEWS
/usr/share/doc/unixODBC/README
/usr/share/doc/unixODBC/README.dist
/usr/share/doc/unixODBC/doc
/usr/share/doc/unixODBC/doc/AdministratorManual
/usr/share/doc/unixODBC/doc/AdministratorManual/index.html
/usr/share/doc/unixODBC/doc/AdministratorManual/odbcinst.html
/usr/share/doc/unixODBC/doc/AdministratorManual/php3.html
/usr/share/doc/unixODBC/doc/AdministratorManual/unixODBC.gif
/usr/share/doc/unixODBC/doc/AdministratorManual/unixODBCsetup.html
/usr/share/doc/unixODBC/doc/ProgrammerManual
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/close.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/conne.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/dsn.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/gloss.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/index.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/intro.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/navi.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/odbc.css
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/query.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/resul.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/index.html
/usr/share/doc/unixODBC/doc/ProgrammerManual/unixODBC.gif
/usr/share/doc/unixODBC/doc/UserManual
/usr/share/doc/unixODBC/doc/UserManual/Figure1.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure2.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure3.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure4.gif
/usr/share/doc/unixODBC/doc/UserManual/Figure6.gif
/usr/share/doc/unixODBC/doc/UserManual/My.sql
/usr/share/doc/unixODBC/doc/UserManual/StarOfficeDataGrid.gif
/usr/share/doc/unixODBC/doc/UserManual/index.html
/usr/share/doc/unixODBC/doc/UserManual/unixODBC.gif
/usr/share/doc/unixODBC/doc/index.html
/usr/share/doc/unixODBC/doc/lst
/usr/share/doc/unixODBC/doc/lst/InternalStructure.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure.vsd
/usr/share/doc/unixODBC/doc/lst/InternalStructure2.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure2.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure3.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure3.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure4.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure4.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure5.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure5.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure6.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure6.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure7.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure7.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure8.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure8.html
/usr/share/doc/unixODBC/doc/lst/InternalStructure9.gif
/usr/share/doc/unixODBC/doc/lst/InternalStructure9.html
/usr/share/doc/unixODBC/doc/lst/back.gif
/usr/share/doc/unixODBC/doc/lst/next.gif
/usr/share/doc/unixODBC/doc/smallbook.gif
/usr/share/doc/unixODBC/doc/unixODBC.gif
/usr/share/man/man1/dltest.1.gz
/usr/share/man/man1/isql.1.gz
/usr/share/man/man1/iusql.1.gz
/usr/share/man/man1/odbc_config.1.gz
/usr/share/man/man1/odbcinst.1.gz
/usr/share/man/man5/odbc.ini.5.gz
/usr/share/man/man5/odbcinst.ini.5.gz
/usr/share/man/man7/unixODBC.7.gz
References
- [unixODBC website](http://www.unixODBC.org/ http://www.unixODBC.org/)
Summary
In this tutorial we learn how to install unixODBC on CentOS 8 using yum and dnf.