unixODBC(7)

📦
version 2.3.14 · 3 versions
  • 2.3.14 · alpine 3.22, alpine 3.23, alpine 3.24, arch rolling, centos-stream 10, centos-stream 9, debian trixie, fedora 43, fedora 44, nixos 26.05, nixpkgs unstable, opensuse-leap 16.0, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking (latest)
  • 2.3.9 · ubuntu jammy
  • 2.3.11 · debian bookworm
, in alpine 3.22, alpine 3.23, alpine 3.24, arch rolling, centos-stream 10, centos-stream 9, debian trixie, fedora 43, fedora 44, nixos 26.05, nixpkgs unstable, opensuse-leap 16.0, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

✨ unixODBC ✨

okay bestie, gather round — this is the manual page for unixODBC, living in the unixODBC(7) section of the unixODBC manual pages. Buckle up, it's short but it's iconic. 💅

🎀 NAME 🎀

unixODBC — An ODBC implementation for Unix 🦋

💖 DESCRIPTION 💖

So like, ODBC is an open specification, right? It hands application developers a predictable API — a whole vibe — that they can use to go talk to data sources. And bestie, when we say "data sources" we mean SQL servers, and honestly literally anything that has an ODBC driver. Slay. ✨

The unixODBC project goals are, and I quote the energy here: to develop and promote unixODBC as the definitive standard for ODBC on non-Windows platforms. Main character energy, fr fr. 👑

Also!! There's an HTML-formatted "Administrator Manual" that ships with unixODBC, and it has extra details on configuration and usage to supplement these man pages. So if you want the deluxe version, that's where it's at. 🎀

🌸 ENVIRONMENT VARIABLES 🌸

These are the env vars, the little levers you can pull. Every single one, no skips. 💜

  • ODBCSYSINI — sets the full path to the directory holding the unixODBC configuration files. By default this is /etc. 🏠
  • ODBCINSTINI — sets the name of the unixODBC driver configuration file. That file name is relative to ODBCSYSINI, and it defaults to odbcinst.ini. 📄
  • ODBCINI — sets the full path to the system-wide unixODBC configuration file that contains the Data Source Names (DSNs). Default? /etc/odbc.ini. 🗂️
  • ODBCINSTUI — sets the library name for the UI. The final name it goes searching for is evaluated as "lib$ODBCINSTUI". By default this variable is odbcinstQ4, so the resulting library name is libodbcinstQ4. 🔍
  • ODBCSEARCH — sets the configuration mode, and that's what decides where to go looking for configuration files. You must set this one to one of ODBC_SYSTEM_DSN, ODBC_USER_DSN or ODBC_BOTH_DSN — and ODBC_BOTH_DSN is the default value. ⭐
no cap, ODBCSEARCH has a strict guest list: only those three values get in. 🙈

🦋 SEE ALSO 🦋

Go read your sisters, they're all so valid: 👑

And also: "The unixODBC Administrator Manual (HTML)" 📖

👑 AUTHORS 👑

The authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@lurcher.org>. Legends, honestly. 🫶

For a full list of contributors, refer to the AUTHORS file. 💜

unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file. 📜

and that's the whole page, bestie — version 2.3.12, dated Thu 07 Jan 2021, brought to you by the unixODBC manual pages. mwah 💋 go forth and connect to your data sources ✨🦋💖

📦 where this page comes from