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)

More Linux Commands

glib-compile-schemas(1) - GSettings schema compiler.........
glib-compile-schemas compiles all the GSettings XML schema files in DIRECTORY into a binary file with the name gschemas.compiled that can be used by GSettings.

FcConfigSetCurrent(3) - Set configuration as default........
Sets the current default configuration to config. Implicitly calls FcConfigBuildFonts if necessary, returning FcFalse if that call fails. VERSION Fontconfig ver

readv(2) - read or write data into multiple buffers.........
The readv() system call reads iovcnt buffers from the file associated with the file descriptor fd into the buffers described by iov (scatter input). The writev(

gst-inspect-0.10(1) - print info about a GStreamer plugin or
gst-inspect is a tool that prints out information on available GStreamer plugins, information about a particular plugin, or information about a particular eleme

Opcode(3pm) - Disable named opcodes when compiling perl code
Perl code is always compiled into an internal format before execution. Evaluating perl code (e.g. via eval or do file) causes the code to be compiled into an in

gnutls_record_recv(3) - API function - Linux manual page....
This function has the similar semantics with recv(). The only difference is that it accepts a GnuTLS session, and uses different error codes. In the special cas

ripoffline_sp(3ncurses) - curses screen-pointer extension...
This implementation can be configured to provide a set of functions which improve the ability to manage multiple screens. This feature can be added to any of th

fabsl(3) - absolute value of floating-point number (ManPage)
These functions return the absolute value of the floating-point number x. RETURN VALUE These functions return the absolute value of x. If x is a NaN, a NaN is r

XcmsCIELuvQueryMaxLC(3) - obtain the CIE L*u*v* coordinates
The XcmsCIELuvQueryMaxC function, given a hue angle and lightness, finds the point of maximum chroma displayable by the screen. It returns this point in CIE L*u

XkbSetDetectableAutoRepeat(3) - Sets DetectableAutoRepeat...
XkbSetDetectableAutoRepeat.3 - Auto-repeat is the generation of multiple key events by a keyboard when the user presses a key and holds it down. Keyboard hardwa

__realloc_hook(3) malloc debugging variables (Man Page).....
The GNU C library lets you modify the behavior of malloc(3), realloc(3), and free(3) by specifying appropriate hook functions. You can use these hooks to help y

gnutls_db_set_remove_function(3) - API function (Man Page)
Sets the function that will be used to remove data from the resumed sessions database. This function must return 0 on success. The first argument to rem_func wi

We can't live, work or learn in freedom unless the software we use is free.