odbcinst - command line tool for batch ODBC configuration


   odbcinst action object options

   action is one of

          -i     install a driver or data source

          -u     uninstall a driver or data source

          -q     query  a  list  of drivers or data sources present on the

          -j     print config info

          -c     call SQLCreateDataSource

          -m     call SQLManageDataSources

                 shows the version number of the program

   object is one of

          -d     an ODBC driver in /etc/odbcinst.ini

          -s     an ODBC Data Source Name (DSN) in an odbc.ini file.

   options are zero or more of

          -f template file
                 Used with -i,  this  option  specifies  a  template  file
                 containing the driver or DSN to be installed.

          -r     Read the template from standard input.

          -n Driver/Data Source Name
                 Used with -u to specify a driver or DSN to remove.

          -v     Contrary  to  standard  practice,  this turns off verbose
                 output; there is no output, even for errors.

          -l     The specified Data Source object  is  a  System  DSN,  in

          -h     The  specified  Data  Source object is a User DSN, in the
                 current user's $HOME/.odbc.ini.  This is the default with


   odbcinst  updates  the  configuration files that control ODBC access to
   database  servers  on  the  current  host.   It   also   maintains   in
   /etc/odbcinst.ini  a  count of the number of references to a particular
   driver, which can be used to determine whether  it  should  be  removed
   from the file (only when the reference count drops to 0).

   Drivers and DSNs are installed using the -i option.

   If the object to be installed is a driver (-d), the specified driver is
   added to /etc/odbcinst.ini or its reference count is incremented if  it
   is already there.

   If the object is a data source (-s), the data source is added either to
   /etc/odbc.ini (if -l is used) or to $HOME/.odbc.ini (the default, which
   can also be specified with -h).

   Uninstalling  a  driver  is  done  with  the command odbcinst -u -d -n
   driver name.  Uninstalling a DSN is done with the command  odbcinst  -u
   -s  -n    data source name.  Uninstalling causes the reference count on
   the object to be decremented.   If  nothing  else  has  requested  this
   driver  or DSN (i.e., the reference count drops to zero), it is removed
   from the config file.

   The options -l and -h are used with -s to specify which  odbc.ini  file
   to configure.

   The  command  odbcinst  -q  -d returns a list of all drivers present in
   /etc/odbcinst.ini.  The command odbcinst -q -s returns a  list  of  all
   system and user DSNs available.


   0      Success



   A typical driver template looks like this:
           Description     = MySQL driver
           Driver          = /usr/lib/odbc/libmyodbc.so
           Setup           = /usr/lib/odbc/libodbcmyS.so

   A DSN template looks like this:
           [Sample DSN]
           Description         = Test MySQL connection
           Driver              = MySQL
           Trace               = Yes
           TraceFile           = /tmp/odbc.log
           Database            = junk
           Server              = localhost
           Port                = 3306
           Socket              =

   The  Description  and  Driver  fields  should  be  present  in  all DSN
   configurations.  Other options are driver-specific; consult  your  ODBC
   driver's   documentation   for  a  list  of  allowed  options,  or  see
   ODBCConfig(1) for a graphical tool that can be  used  to  interactively
   set up a DSN or driver the first time.


   /etc/odbcinst.ini, /etc/odbc.ini, $HOME/.odbc.ini


   This  manual  page  was written by Oliver Elphick <olly@lfix.co.uk> and
   Steve Langasek <vorlon@debian.org> for the Debian package of unixODBC.


   ODBCConfig(1), gODBCConfig(1)


Personal Opportunity - Free software gives you access to billions of dollars of software at no cost. Use this software for your business, personal use or to develop a profitable skill. Access to source code provides access to a level of capabilities/information that companies protect though copyrights. Open source is a core component of the Internet and it is available to you. Leverage the billions of dollars in resources and capabilities to build a career, establish a business or change the world. The potential is endless for those who understand the opportunity.

Business Opportunity - Goldman Sachs, IBM and countless large corporations are leveraging open source to reduce costs, develop products and increase their bottom lines. Learn what these companies know about open source and how open source can give you the advantage.

Free Software

Free Software provides computer programs and capabilities at no cost but more importantly, it provides the freedom to run, edit, contribute to, and share the software. The importance of free software is a matter of access, not price. Software at no cost is a benefit but ownership rights to the software and source code is far more significant.

Free Office Software - The Libre Office suite provides top desktop productivity tools for free. This includes, a word processor, spreadsheet, presentation engine, drawing and flowcharting, database and math applications. Libre Office is available for Linux or Windows.

Free Books

The Free Books Library is a collection of thousands of the most popular public domain books in an online readable format. The collection includes great classical literature and more recent works where the U.S. copyright has expired. These books are yours to read and use without restrictions.

Source Code - Want to change a program or know how it works? Open Source provides the source code for its programs so that anyone can use, modify or learn how to write those programs themselves. Visit the GNU source code repositories to download the source.


Study at Harvard, Stanford or MIT - Open edX provides free online courses from Harvard, MIT, Columbia, UC Berkeley and other top Universities. Hundreds of courses for almost all major subjects and course levels. Open edx also offers some paid courses and selected certifications.

Linux Manual Pages - A man or manual page is a form of software documentation found on Linux/Unix operating systems. Topics covered include computer programs (including library and system calls), formal standards and conventions, and even abstract concepts.