odbcinst(1): - command line tool for batch ODBC configuration

NAME

   odbcinst - command line tool for batch ODBC configuration

SYNOPSIS

   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
                 system

          -j     print config info

          -c     call SQLCreateDataSource

          -m     call SQLManageDataSources

          --version
                 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
                 /etc/odbc.ini.

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

DESCRIPTION

   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).

   Installing
   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
   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.

   Queries
   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.

EXIT STATUS

   0      Success

   non-zero
          Failure

TEMPLATE FILES

   A typical driver template looks like this:
           [MySQL]
           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.

FILES

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

AUTHOR

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

More Linux Commands

manpages/glib-compile-schemas.1.html
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.

manpages/FcConfigSetCurrent.3.html
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

manpages/readv.2.html
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(

manpages/gst-inspect-0.10.1.html
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

manpages/Opcode.3pm.html
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

manpages/gnutls_record_recv.3.html
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

manpages/ripoffline_sp.3ncurses.html
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

manpages/fabsl.3.html
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

manpages/XcmsCIELuvQueryMaxLC.3.html
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

manpages/XkbSetDetectableAutoRepeat.3.html
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

manpages/__realloc_hook.3.html
__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

manpages/gnutls_db_set_remove_function.3.html
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.

"Free learning resources, like free software, is a matter of freedom, not price. It's about bringing the principles of free software to general knowledge and educational materials. Knowledge should be usable and accessible to all without restrictions and should not be treated as property." Free Learning Resources

"As our society grows more dependent on computers, the software we run is of critical importance to securing the future of a free society. Free software is about having control over the technology we use in our homes, schools and businesses, where computers work for our individual and communal benefit" Learn About Free Software