|
|
|
Permission required: Access to the directory where the utility is located.
The iiodbcinst utility modifies or creates the ODBC configuration file, odbcinst.ini, on UNIX and VMS. For more information on configuring the Ingres ODBC driver, see the Connectivity Guide.
Note: The iiodbcinst utility does not write the ODBC data source configuration file odbc.ini.
The iiodbcinst command has the following format:
iiodbcinst [-batch] [-m drvmgr] [-p altpath] [-rmpkg ] [-r]
Overwrites the odbcinst.ini file without prompting for confirmation.
Specifies the driver manager used in the ODBC installation. Valid values for drvmgr include unixODBC and CAI/PT.
Indicates an alternate target path for the odbcinst.ini file. The default value is /usr/local/etc or the definition of ODBCSYSINI.
Removes the driver definition from the odbcinst.ini file.
Forces all ODBC sessions to reject database updates (sets to read only).
|
|
|
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:
iiodbcinst -p /ingres/odbcConfig
When you invoke the Ingres ODBC Administrator (iiodbcadmn), 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.