Follow these steps to create
ODBC connections with required stored credentials in the UNIX and Linux ODBC operating environments:
-
Execute the following
command:
install-path/bin/dfdbconf
-
Select a driver from
the list of available drivers.
-
Set the appropriate
parameters for the driver. The new data source is added to the odbc.ini
file, which is stored at
install-path/etc
.
Note: You can also use dfdbconf
to delete the data sources.
-
Add stored credentials
to the data source by executing the following command:
install-path/bin/dfdbview -s data-source-name
-
Test the new data source
by executing the following command:
install-path/bin/dfdbview data-source-name
-
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.