SQL/R A.03.00 Release NotesWelcome to the SQL/R A.03.00 release.
SQL/R provides SQL access to the Eloquence database.
The SQL/R ODBC Driver enables easy and transparent access to the
Eloquence database from ODBC aware applications.
- The SQL/R Report Generator provides an easy and flexible method to create reports on the fly, based on the SQL database query language.
Note that the above two SQL/R product options are licensed separately.
The SQL/R A.03.00 release implements a number of enhancements.
- Encrypted communication
SQL/R A.03.00 adds a secure network protocol, using an RSA encrypted key exchange method and AES session encryption key.
- LDAP support
SQL/R A.03.00 adds the LDAP user authentication method.
SQL/R A.03.00 supports the Eloquence database auditing function.
The ODBC driver submits login, user and process audit information
through the SQL/R server to the Eloquence database server.
- Encrypted passwords
SQL/R A.03.01 adds support for storing passwords in an encrypted form.
SQL/R A.03.01 adds support for groups (security = ODBC and LDAP).
- Linux systemd support
As of A.03.21, SQL/R on the Linux platform preferably uses systemd to manage services, where available.
The current SQL/R A.03.00 version is A.03.21.
Fixed Problems and Recent Changes
Installation and UpgradePlease refer to the SQL/R A.03.00 installation documents below for an overview of SQL/R installation and platform specific details, as well as information on updated License Keys.
- Installation notes
- License keys
SQL/R A.03.00 license keySQL/R A.03.00 requires a license key revision of A.03.00 or higher. A previous license key does no longer work.
If an Eloquence Personal Edition is installed and no valid SQL/R license key is detected, a two user license is granted automatically.
To request a SQL/R license key, please contact firstname.lastname@example.org.
ODBC driver backwards compatibilityThe SQL/R A.03.00 ODBC server is fully backwards compatible to previous ODBC drivers. Consequently, updating the ODBC server side to A.03.00 server does not require updating all clients.
The SQL/R A.03.00 client / ODBC driver by default uses a new network protocol which supports the encryption and auditing functionality. This protocol is not backwards compatible with previous SQL/R A.02.xx server versions.
To communicate with a previous SQL/R A.02.xx server, the SQL/R client / ODBC driver must be configured to use the backwards-compatible A02 network protocol.
The A02 network protocol is used:
if the environment variable SQLR_PROTOCOL=A02 is set
if the Protocol=A02; option in the ODBC connection string
if the Protocol=A02 option is specified in the data source
definition in the odbc.ini configuration file of the ODBC
on the Windows platform, if the option to use the A02
network protocol is checked in the data source configuration
- on the Windows platform, if Protocol=A02 is configured in the [Config] section of the ODBC driver configuration file (Start Menu - Programs - SQLR - ODBC Driver Configuration).