The following example creates an ODBC configuration file in an alternate directory.

In the example, the driver manager is unixODBC, and the default search path of the unixODBC driver manager is /usr/local/etc. However, your installation does not allow non-privileged users to access /usr/local/etc.

To write an odbcinst.ini file to the path /ingres/odbcConfig, instead of the default /usr/local/etc, enter this command:

When you invoke the Ingres ODBC Administrator (iiodbcadmin), the default system path is displayed as “ALTERNATE.”

Since the default search path for unixODBC is different from your intended path, you need to define the environment variable ODBCSYSINI to execute ODBC applications. You may therefore have defined ODBCSYSINI prior to executing iiodbcinst. If this is the case, it is not necessary to supply the -p argument for iiodbcinst, because iiodbcinst already supports ODBCSYSINI. Furthermore, the Ingres ODBC Administrator displays the default search path as “SYSTEM.”

See also iisuodbc Command--Run iiodbcinst Utility.