odbcinst (1) Linux Manual Page

odbcinst – An unixODBC tool for manipulating configuration files

Synopsis

odbcinst ACTION OBJECT OPTIONS

Description

odbcinst is a command line tool which has been created for allowing people who are developing the install scripts/RPMs for Drivers to be able to easily create/remove entries in odbc.ini and odbcinst.ini. This command line tool is a complement to the shared library of the same name (libodbcinst.so). This tool is a part of the odbcinst component of unixODBC.

Options

Actions

-i

Install (add section to config file) new OBJECT.

-u

Uninstall (remove section from config file) existing OBJECT.

-q

Query the config files and print the options for specified OBJECT.

-j

Prints current configuration of unixODBC, listing (among others) the paths to the configuration files.

-c

Calls SQLCreateDataSource

-m

Calls SQLManageDataSources

–version

Prints program version and exits.

Objects

-d

The ACTION affect drivers (and thus the odbcinst.ini configuration file).

-s

The ACTION affect data sources (and thus the user or system odbc.ini configuration file).

Options

-f FILE

The FILE is template file, describing the configuration of installed OBJECT (only valid for the -i ACTION).

-r

Same as the -f OPTION, only take the standard input as the template file.

-n NAME

Specifies the NAME of the OBJECT.

-v

Turn off verbose mode. This turns off all information, warning and error messages.

-l

The specified data source is system-wide. Has any effect only with the -s OBJECT.

-h

The specified data source is user-specific. Has any effect only with the -s OBJECT.

Return Values

This command returns zero on success and non-zero value on failure.

Files

/etc/odbinst.ini

Configuration file containing all the database drivers specifications. See odbcinst.ini(5) for more details.

/etc/odbc.ini

System-wide data sources specifications. See odbc.ini(5) for more details.

$HOME/.odbc.ini

User-specific data sources specifications. See odbc.ini(5) for more details.

See Also

odbcinst.ini(5), odbc.ini(5)

Authors

The authors of unixODBC are Peter Harvey <pharvey [at] codebydesign.com> and Nick Gorham <nick [at] easysoft.com>. For the full list of contributors see the AUTHORS file.

Copyright

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