Configuration

The SQL/R ODBC server is configured by editing the odbc.cfg, odbc.user and odbc.dsn configuration files.

• The odbc.cfg file defines the server defaults and behaviour.

• The odbc.dsn file defines the data sources.

• The odbc.user file defines the ODBC users.

• The odbc.pswd file holds encrypted passwords. It is maintained with the sqlrpasswd utility and should not be changed manually.

Location of Configuration files

SQL/R configuration files are located in the following directory:

• On the HP-UX and Linux platform, configuration files reside in the /etc/opt/sqlr2 directory. Template configuration files are available in the /opt/sqlr2/newconfig/config directory. By default, root capabilities are required to change the configuration.

• On the Windows platform SQL/R configuration files reside in the etc subdirectory of the SQL/R installation directory.
  Template configuration files are available in the same directory with an additional ".sam" extension. Please note that on Windows Vista or newer membership in the "SQLR Administrators" group is required to edit the configuration files.