======================================================================

SQL/R A.03.11 - 23.05.2014

======================================================================

SQL/R provides SQL access to the Eloquence database.

- The SQL/R Report Generator provides an easy and flexible method
  to create reports on the fly. The SQL/R script language enables
  SQL based access to the database.
- The SQL/R ODBC Driver allow the easy integration of ODBC aware
  applications with the Eloquence database.

More information on SQL/R is available on the Internet at
http://www.marxmeier.com/sqlr/

If you encounter problems using this software, please send an email
message to the SQL/R support team at support@marxmeier.com


Documents
---------

README          - This document
RELNOTES        - SQL/R release notes
RELNOTES-ODBC   - ODBC release notes for the UNIX platform


SQL/R A.03.xx
-------------

* SQL/R A.03.xx supported platforms:

  - HP-UX PA-RISC based systems: HP-UX 11iv1 (11.11) or newer
  - HP-UX Itanium based systems: HP-UX 11iv2 (11.23) or newer
  - Linux glibc2.3 based systems or newer
  - Windows 2000, XP, 2003, Vista, 2008, Windows 7 and Windows 8

* In addition to the Eloquence database since version A.06.xx,
  the Eloquence database version A.05.xx is supported on the
  HP-UX PA-RISC platform.

* SQL/R A.03.xx adds a secure network protocol, using an RSA
  encrypted key exchange method and AES session encryption key.

* SQL/R A.03.xx adds the LDAP user authentication method.

* SQL/R A.03.xx 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.

* SQL/R uses the ODBC server backend to access the database.
  A builtin backward compatibility mode provides compatibility
  with most of the existing SQL/R scripts.

* 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).


Platform differences
--------------------

* The A.05.xx database is only supported on the HP-UX PA-RISC
  platform.

* On the Linux platform, the lprint and tmap utilities are
  currently not available. In addition, no character set mapping
  is performed. The ISO-88591-1 character encoding is assumed.
  You can use the GNU recode utility (included with Linux) to
  convert output to other charcter set encodings if required.

* On Windows the sqlr, sqlred, lprint and tmap utilities are
  not available. The ISO-88591-1 character encoding is assumed.


SQL/R A.03.xx license key
-------------------------

SQL/R A.03.xx requires a license key revision of A.03.00 or higher.
A previous license key for version A.01.xx or A.02.xx 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 receive a permanent SQL/R license key, please contact
sales@marxmeier.com.


Using a previous SQL/R A.02.xx server
-------------------------------------

The SQL/R A.03.xx client / ODBC driver by default uses a new
network protocol which supports the encryption and auditing
functionality.

This protocol is no longer 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 use the backward-compatible A02 network
protocol.

The A02 network protocol is used:
- either if the environment variable SQLR_PROTOCOL=A02 is set
- or if the Protocol=A02; option in the ODBC connection string
  is specified
- or if the Protocol=A02 option is specified in the data source
  definition in the odbc.ini configuration file of the ODBC
  driver manager
- or, on the Windows platform, if the option to use the A02
  network protocol is checked in the data source configuration
  dialog
- or, 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).