User Guide > User Guide > A. Command Reference > iiodbcadmin Command--Run ODBC Administrator
Was this helpful?
iiodbcadmin Command--Run ODBC Administrator
Valid in non-Windows environments only.
The iiodbcadmin command runs the ODBC Administrator.
This command has the following format:
iiodbcadmin [[[help|-help|--help] [attribute]] |
[-version|--version|-v|--v] | [[add|delete|modify|prompt|test|show|discover]
[dsnName]] [-raw|--raw] [-changed]]] [-batch|--batch] [-user|--user]
[-full|--full] [attribute=value[ attribute=value...]]
(No arguments)
Runs in interactive mode.
help, -help, --help
Displays help page. All other arguments are ignored except attribute.
attribute
Displays a list of supported attributes and their values, when used with the help option.
-version, --version, -v, --v
Displays names and versions of installed ODBC drivers.
add
Adds a DSN. If dsnName not specified, creates a DSN named demodb. If dsnName is specified, the target database is the same name as dsnName. This option supports attribute/value pairs.
delete
Deletes a DSN. If dsnName is not specified, deletes demodb.
modify
Modifies a DSN attribute. If dsnName is not specified, modifies demodb. This option supports attribute/value pairs.
prompt
Interactively prompts for minimum connection attributes and tests a connection. If the connection is successful, the attributes can be saved as the specified DSN. This option supports attribute/value pairs.
test
Tests a connection for an existing DSN. If dsnName is not specified, tests demodb.
show
Shows the contents of the ODBC configuration file. if dsnName is specified, shows only dsnName.
discover
Shows the location of the odbcinst.ini, system-level odbc.ini and user-level odbc.ini files. If ODBCSYSINI is not defined, the alternate path is displayed, if defined. If an alternate path is not defined, the default path for system-level files and the user-level odbc.ini file is displayed.
dsnName
Specifies the ODBC Data Source Name. Example: odbcdb.
-raw, --raw
For the show command, shows the contents of the ODBC configuration file without formatting.
-changed, --changed
For the show command, shows attributes that differ from the default settings.
-batch, --batch
Executes without displaying output.
-full, --full
For the add and prompt commands, adds full set of DSN attributes. By default, only the minimum set of attributes is added.
-user, --user
For the add, delete, modify, show, and prompt commands, uses the user-level configuration file. By default, only the system-level configuration file is used.
attribute=value
Specifies a setting that defines the data source and connection information. To see supported attributes and their values, issue the command iiodbcadmin help attribute.
Last modified date: 11/09/2022