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:
-
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 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.
-
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.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: June 16, 2017