Use dfdbconf and dfdbview for UNIX and Linux ODBC Connections

Follow these steps to create ODBC connections with required stored credentials in the UNIX and Linux ODBC operating environments:
  1. Execute the following command:
    install-path/bin/dfdbconf
  2. Select a driver from the list of available drivers.
  3. Set the appropriate parameters for the driver. The new data source is added to the default odbc.ini file, which is stored at install-path/etc.
    Note: If you specify an alternate path in the environment variable ODBCINI, then the server ignores the default file and the new data source.
    Note: You can also use dfdbconf to delete the data sources.
  4. Add stored credentials to the data source by executing the following command:
    install-path/bin/dfdbview -s data-source-name
  5. Test the new data source by executing the following command:
    install-path/bin/dfdbview data-source-name
  6. If the connection succeeds, use the prompt to enter SQL commands to test the connection. If the connection fails, resolve the errors described in the error messages.
Last updated: June 16, 2017