odbcinst(1)

๐Ÿ“ฆ
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

โœจ odbcinst(1) โ€” bestie edition โœจ

okay so. this is a page from the unixODBC manual pages and it's about a lil command called odbcinst ๐Ÿ’… buckle up.


๐ŸŒธ NAME ๐ŸŒธ

odbcinst โ€” a unixODBC utility for managing configuration files ๐ŸŽ€


๐Ÿฆ‹ SYNOPSIS ๐Ÿฆ‹

odbcinst ACTION OBJECT OPTIONS

๐Ÿ’– DESCRIPTION ๐Ÿ’–

odbcinst is a command-line utility that lets people who write install scripts or packages for ODBC drivers easily create or remove entries in odbc.ini and odbcinst.ini. that's literally its whole job and it eats every time ๐Ÿ”ฅ

this utility is part of the odbcinst component of unixODBC, and it complements the shared library of the same name (libodbcinst). they're a duo, they're iconic, they come as a set ๐Ÿ‘‘


โœจ OPTIONS โœจ

๐ŸŽฏ ACTIONS

  • -i โ€” install a new OBJECT (by adding a section to a configuration file). new OBJECT just dropped ๐Ÿ™ˆ
  • -u โ€” uninstall an existing OBJECT (by removing a section from a configuration file). not me deleting a whole section ๐Ÿ’€
  • -q โ€” query ODBC configuration files and print the available options for the specified OBJECT. it's giving investigative journalist ๐Ÿ”
  • -j โ€” print the current configuration of unixODBC, including the paths to the configuration files. the vibe check of your whole setup ๐ŸŒˆ
  • -c โ€” call SQLCreateDataSource.
  • -m โ€” call SQLManageDataSources.
  • --version โ€” display the program version. gotta know which era you're in โญ

๐ŸŽ€ OBJECTS

  • -d โ€” the specified ACTION affects a driver (and thus the odbcinst.ini configuration file).
  • -s โ€” the specified ACTION affects a data source (and thus the user or system odbc.ini configuration file).

๐Ÿ’… OPTIONS

  • -f FILE โ€” FILE is a template describing the configuration of the installed OBJECT. this one is only valid with the -i ACTION, no exceptions bestie.
  • -r โ€” act in the same way as for the -f OPTION, but take standard input as the template file. same energy, different source ๐Ÿซถ
  • -n NAME โ€” specifies the NAME of the OBJECT. give it a name, it deserves one ๐Ÿ’œ
  • -v โ€” disable all information, warning and error messages. quiet mode, silent treatment, we love her ๐Ÿ˜ญ
  • -l โ€” the specified data source is system-wide. this option is only valid when used with the -s OBJECT.
  • -h โ€” the specified data source is user-specific. this option is only valid when used with the -s OBJECT.

โญ RETURN VALUES โญ

odbcinst returns zero on success and a non-zero value on failure. that's it. that's the whole scoring system ๐ŸŽฏ


๐ŸŒˆ FILES ๐ŸŒˆ

  • /etc/odbcinst.ini โ€” configuration file containing all database driver definitions. see odbcinst.ini(5) for more information. ๐Ÿ‘‘
  • /etc/odbc.ini โ€” configuration file containing system-wide Data Source Name (DSN) definitions. see odbc.ini(5) for more information.
  • $HOME/.odbc.ini โ€” configuration file containing user-specific Data Source Name (DSN) definitions. see odbc.ini(5) for more information. it's your personal one, your own lil corner of the filesystem ๐Ÿ“

๐Ÿ’œ SEE ALSO ๐Ÿ’œ

odbcinst.ini(5), odbc.ini(5) โ€” go read those next, iykyk ๐Ÿ“š


๐Ÿงš AUTHORS ๐Ÿงš

the authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@lurcher.org>. absolute legends, no cap ๐Ÿซถ

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, every last flag accounted for, nothing skipped, periodt ๐Ÿ’…โœจ

this was version 2.3.12, dated Sat 09 Jan 2021, and it's the odbcinst(1) page from the unixODBC manual. mwah, go configure something iconic ๐ŸŒธ

๐Ÿ“ฆ where this page comes from