README
     Progress(R) DataDirect(R)
     Progress DataDirect for ODBC for SQL Server Wire Protocol Driver 

     UNIX and Linux Platforms (32- and 64-bit) 
     8.0.2 Release   
     April 3, 2019

***********************************************************************
Copyright (c) 2019 Progress Software Corporation and/or its 
subsidiaries or affiliates. All Rights Reserved.  
***********************************************************************

This README file contains information for Progress(R) DataDirect(R)  
for ODBC SQL Server(TM) Wire Protocol Driver. 

This README file contains information not included in the PROGRESS 
DATADIRECT FOR ODBC SQL SERVER USER'S GUIDE AND REFERENCE.



CONTENTS

Installation Directory
Changes Since 8.0.2 GA 
Changes for 8.0.2 GA   
Configuring Data Sources
Driver WorkAround Options
Notes, Known Problems, and Restrictions
Documentation
Installed Files for the 32-bit Driver
Installed Files for the 64-bit Driver 
    
	
	    Installation Directory 

* The default installation directory for the 32-bit driver is:

  /opt/Progress/DataDirect/ODBC_80

* The default installation directory for the 64-bit driver is:

  /opt/Progress/DataDirect/ODBC_80_64bit
  
  
   Changes Since 8.0.2 GA 
  
SSL Enhancement (1.0.2r) 
------------------------
The default OpenSSL library version has been updated to 1.0.2r, which fixes the 
following security vulnerabilities:
 * 0-byte record padding oracle (CVE-2019-1559)
 * Microarchitecture timing vulnerability in ECC scalar 
   multiplication (CVE-2018-5407)
 * Timing vulnerability in DSA signature generation (CVE-2018-0734)
 * Client DoS due to large DH parameter (CVE-2018-0732)
 * Cache timing vulnerability in RSA Key Generation (CVE-2018-0737)
 * Constructed ASN.1 types with a recursive definition could exceed the 
   stack (CVE-2018-0739)
 
This upgrade is available starting in build 08.02.0194 of the OpenSSL library 
file.  
 
Version 1.0.2r also addresses vulnerabilities resolved by earlier versions of 
the library.  

For more information on OpenSSL vulnerabilities resolved by this upgrade, refer
to the corresponding OpenSSL announcements at 
https://www.openssl.org/news/vulnerabilities-1.0.2.html. 

	
    Changes for 8.0.2 GA

Platform Certifications 
-----------------------	
* Certified with Red Hat Enterprise 7.3 
* Certified with Debian Linux 7.11, 8.5 
* Certified with Ubuntu Linux 14.04, 16.04 

Data Source Certifications
--------------------------
* Certified with Microsoft Azure SQL Data Warehouse 12.00
* Certified with Microsoft Analytics Platform System 10.00
* Certified with Microsoft SQL Server 2017 
* Certified with Microsoft SQL Server 2016 

Support for Microsoft Azure SQL Data Warehouse and 
Microsoft Analytics Platform System
--------------------------------------------------
The driver has been enhanced to transparently connect to Microsoft Azure SQL 
Data Warehouse and Microsoft Analytics Platform System data sources. For more 
information about supported features and functionality, refer to "Support for 
Azure Data Warehouse and Analytics Platform System" in the user's guide.

HTTP Proxy Support
------------------
The driver has been enhanced to support for connecting to a proxy server 
through an HTTP connection. HTTP proxy support is configurable with five new 
connection options: ProxyHost, ProxyMode, ProxyPassword, ProxyPort, 
and ProxyUser.

EnableServerSideCursors Connection Option 
--------------------------------------------
The new EnableServerSideCursors connection option allows you to determine 
which server-side cursors are enabled for the data source. 

Azure AD Authentication
-----------------------  
The driver is enhanced to support Azure Active Directory authentication 
(Azure AD). Azure AD authentication is an alternative to SQL Server 
Authentication for Azure SQL Database that allows you to centrally manage
identities of database users. To enable Azure AD authentication, specify the
new 13 (Active Directory Password) value for the Authentication Method 
connection option (AuthenticationMethod=13). In addition, specify the 
respective values in the connection string or data source definition for the
HostNameInCertificate, Truststore, ValidateServerCertificate, LogonID and 
Password connection options. Refer to "Configuring Azure Active Directory 
Authentication" in the user's guide for more information.

Always On Availability Groups 
-----------------------------
The driver has been enhanced to support Always On Availability Groups. 
Introduced in SQL Server 2012, Always On Availability Groups is a 
replica-database environment that provides a high-level of data availability,
protection, and recovery. To support this enhancement, the following updates
have been made to the driver:

 - The new MultiSubnetFailover option allows the driver to attempt parallel 
   connections to all the IP addresses associated with an availability group 
   listener when the primary listener is unavailable. This offers improved 
   response time over traditional failover, which attempts connections to 
   alternate servers one at a time. This option must be enabled for failover 
   to work properly in an Always On environment. 

 - The HostName option has been updated to support the virtual network 
   name (VNN) of the availability group listener as a valid value. To connect
   to an Always On Availability group, you must specify the VNN using this 
   option.

 - The new ApplicationIntent option allows you to control whether the driver
   requests read-only routing, thereby improving efficiency by reducing the 
   workload on read-write  nodes. 
 
UTF-8 Support in the odbc.ini and odbcinst.ini Files
----------------------------------------------------
The driver and Driver Manager have been enhanced to support UTF-8 encoding in 
the odbc.ini and odbcinst.ini files. 

Default Value for CryptoProtocolVersion
---------------------------------------
The default value for CryptoProtocolVersion has been updated to TLSv1.2,
TLSv1.1,TLSv1. This change improves the security of the driver by employing 
only the most secure cryptographic protocols as the default behavior. 

SSL Enhancement (1.0.2n) for All SSL-Enabled Drivers
----------------------------------------------------
Note: OpenSSL library 1.0.2n has been replaced with version 1.0.2r. In addition
to fixing multiple new vulnerabilities, version 1.0.2r also addresses the 
vulnerabilities resolved by version 1.0.2n. 

Version 1.0.2n of the OpenSSL library fixes the following security 
vulnerabilities:
 * rsaz_1024_mul_avx2 overflow bug on x86_64(CVE-2017-3738)
 * Read/write after SSL object in error state (CVE-2017-3737)
 * bn_sqrx8x_internal carry bug on x86_64 (CVE-2017-3736)
 * Malformed X.509 IPAddressFamily could cause OOB read (CVE-2017-3735) 	

 
Refer to the user's guide for additional information on these changes. 


    Required Operating System Patches 

For HP-UX 11 aCC Users Only
---------------------------
The ODBC drivers for HP-UX 11 aCC are supported on HP-UX 11.0
when running with HP-UX applications built using the HP aCC
compiler version 3.05 or higher.
The ODBC drivers require certain runtime library patches. HP-UX
patches are publicly available from the HP Web site (www.hp.com). The
required patch is:
PHSS_14577
HP updates the patch database regularly; therefore, the patch
numbers in this file may be superseded by newer versions. If you
search for any of the specified patches on an HP site and receive
a message that a patch has been superseded, download and install
the replacement patch.  

 
    Configuring Data Sources

Data sources are stored in the system information file (typically, 
odbc.ini). For details on configuring this file, see the PROGRESS DATADIRECT
FOR ODBC FOR SQL SERVER DRIVER USER'S GUIDE AND REFERENCE.
 
 
     Driver WorkAround Options

Progress DataDirect has included non-standard connection options 
(workarounds) for the drivers that enable you to take full advantage of 
packaged ODBC-enabled applications requiring non-standard or extended 
behavior.

Refer to the chapter "WorkAround Options" in the User's Guide and Reference
for a description of these options.


     Notes, Known Problems, and Restrictions

The following are notes, known problems, or restrictions with 
Release 8.0.2 of the Progress DataDirect for ODBC for SQL Server Wire 
Protocol driver.  

For SSL Users
-------------
When trying to connect to a database using SSL encryption, you may 
receive an error message similar to: "PRNG not seeded". This is because 
certain versions of some operating systems do not generate truly random 
numbers necessary for encryption. For more information about this error 
and available patches, please refer to the Web site:

http://www.openssl.org/support/faq.html#USER1

ODBC Development on UNIX and Linux Platforms
--------------------------------------------
All of the Release 8.0 Core Components (header files, etc.) needed for
development of ODBC applications on UNIX and Linux are installed into
the /include directory created by the product installer.

Please read the notices.txt file in the installation directory for
licensing information regarding the ODBC Core Components. Contact your
Progress DataDirect representative if you have any questions.

Developers using programming languages other than C++:
The DataDirect ODBC Driver Manager is a C++ shared library. The ODBC
Driver Manager can be used with any language that supports loading a
C++ shared library; however, if you are using a programming language
other than C++, you must take additional steps to ensure that the C++
libraries are initialized properly when loaded. If you are not using
C++, consult your compiler documentation for instructions on using C++
shared libraries with your application.

LANG Environment Setting on UNIX and Linux Platforms
----------------------------------------------------
A default installation of the product on UNIX and Linux assumes that
the value of the LANG environment setting is en_US. If your locale is
not set to en_US, the drivers may not return error messages properly.
In this case, you must create a symbolic link in the
/locale directory that has the same value as the LANG
environment setting. This link must point to the
/locale/en_US directory.

SQLColAttribute(s)
------------------
The column attributes 1001 and 1002, which were assigned as DataDirect- 
specific attributes, were inadvertently used as system attributes by
the Microsoft 3.0 ODBC implementation. Applications using those 
attributes must now use 1901 and 1902, respectively.

SQL_C_NUMERIC
-------------
Because of inconsistencies in the ODBC specification, users attempting 
to use SQL_C_NUMERIC parameters must set the precision and scale values 
of the corresponding structure and the descriptor fields in the 
Application Parameter Descriptor.

For Developers Using IIS
------------------------
One of the most common connectivity issues encountered while using IIS 
(Microsoft's Internet Information Server) concerns the use and settings 
of the account permissions. If you encounter problems using DataDirect 
drivers with an IIS server, refer to KnowledgeBase document number 4274 
on the Progress DataDirect web site:

http://knowledgebase.datadirect.com.

Microsoft SQL Server Limitations
--------------------------------
Attempting to execute DDL statements that contain errors causes 
an implicit rollback of the current transaction if executing in 
manual commit mode. No warning occurs when this happens. This is a 
Microsoft SQL Server limitation, and no driver workaround is available.

NOTE: Because the SQL Server Wire Protocol drivers do not have a way to 
prepare statements, the driver does not send those statements to the 
server until SQLExecute is called. PREPARE does not return any of the 
normal errors that most of the drivers return. If, however, the user 
requests information about result columns, the driver executes a Select 
statement and returns warnings or errors when using SQLNumResultCols, 
SQLDescribeCol, or SQLColAttributes.

Catalog Functions
-----------------
If you have problems with the catalog functions returning incorrect 
data, you may need to upgrade your catalog stored procedures. Make 
sure that you have installed the latest version of the stored  
procedures, which are available from your database vendor. Refer to 
your Microsoft SQL Server documentation for more information.

The SQL Server Wire Protocol drivers return stored procedure names with 
the version number appended to them. For example, a procedure defined 
as "proc1" will be returned as "proc1;1".

For AIX Users
------------------------------
Some IBM AIX C compilers, such as xlc 3.1.4, do not support the use
of C++ build binaries. C developers on AIX should consult their
compiler documentation and verify that their AIX C compiler supports
the use of C++ shared libraries or the application could be unstable.
Unexpected behavior may occur randomly if the LIBPATH variable
exceeds 178 characters.


    Documentation	 	 

THE PROGRESS DATADIRECT FOR ODBC FOR SQL SERVER WIRE PROTOCOL DRIVER
USER'S GUIDE AND REFERENCE
----------------------------------------------------------------------
This guide is provided in PDF and HTML versions. Both versions are installed
in the SQLServerHelp subdirectory of your product installation directory. You 
can access the help by opening the index.html file.

The complete documentation library is available on the Progress DataDirect 
Web site at https://www.progress.com/documentation/datadirect-connectors.


    Uninstalling the Driver 

You can uninstall the product or individual drivers using the 
uninstall_ODBC_80 file in the /uninstall folder of the installation directory.


    Installed Files the 32-bit Driver

This file list assumes a full installation of the driver and 
documentation.

The installer copies the following files and subdirectories to the 
product installation directory, by default:

/opt/Progress/DataDirect/ODBC_80:


odbc.csh                         Setup script for C shell
odbc.ini                         Sample odbc.ini file
odbcinst.ini                     Sample odbcinst.ini file
odbc.sh                          Setup script for Bourne shell
IVODBC.LIC                       DataDirect license file
fixes.txt                        List of fixes since last release
license.txt                      Progress DataDirect license agreement

/bin:
ivtestlib                        Test application to check that required 
                                 libraries are present and loadable
								 
/help: 
sqlserverwp_connect.txt          Help text for the SQL Server WP driver 
                                 SQLDriverConnect dialog 
/help/SQLServerHelp:
index.html                       HTML help system entry file
*.*                              Support folders for the HTML help system

/include:
odbcinst.h                       Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h

/lib:
ivsqls28.so                      SQL Server WP driver  
ivtrc28.so                       Progress DataDirect trace library
libivcurl28.so                   Library used for HTTP connections [.a on AIX]
libivicu28.so                    Unicode conversion tables  [.a on AIX]
libivmback.so                    SQLDriverConnect Motif library 
libivmbackw.so                   SQLDriverConnect Motif library [.a on AIX]
libivssl28.so	                 SSL support file (1.0.2r)[.a on AIX]
libodbc.so                       ODBC Driver Manager [.a on AIX]
libodbcinst.so                   ODBC Installer [.a on AIX]
odbc.so                          ODBC Driver Manager (dynamically loadable) 
                                 [AIX only]
odbccurs.so                      ODBC Cursor library 
odbcinst.so                      ODBC Installer (dynamically loadable) 
                                 [AIX only]
vscnctdlg.so                     ODBC library for Motif operations

/OpenSSL:
latest/libivssl28.so             SSL support file (OpenSSL library 
                                 version 1.0.2r) [.a on AIX] 
1.0.2d/libivssl28.so             SSL support file (OpenSSL library 
                                 version 1.0.2d) [.a on AIX] 						 

/locale/en_US/LC_MESSAGES:
ivmbackw.mo                      Motif library message file
ivmbackw.po                      Motif library message source
ivsqls28.mo                      SQL Server WP driver message file
ivsqls28.po                      SQL Server WP driver message file source
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source


/NOTICES:
ODBC for SQL Server  
v8.0 notices.txt                 Third-party vendor license agreements	


/READMES:
ODBC for SQL Server  
v8.0 readme.txt	                 This file

/samples:
/bulk/bulk                       Bulk application
/bulk/bulk.c                     Bulk example source
/bulk/bulk.mak                   Bulk example make file
/bulk/bulk.txt                   Bulk example description

/bulkstrm/bulk.cpp               Bulk streaming example source
/bulkstrm/bulk.hpp               Bulk streaming example header
/bulkstrm/bulkstrm               Bulk streaming example application
/bulkstrm/bulkstrm.txt           Bulk streaming example description
/bulkstrm/main.cpp               Bulk streaming example source
/bulkstrm/msgprintf.hpp          Bulk streaming example header
/bulkstrm/streambulk.mak         Bulk streaming example make file

/example/example                 Example application
/example/example.c               Example source
/example/example.h               Example header
/example/example.mak             Example make file
/example/example.txt             Example description

/tools:
ddextu                           License Extender utility
ddprocinfo                       Processor Information utility


	Installed Files for the 64-bit Driver

This file list assumes a full installation of all drivers and 
documentation. 

The installer copies the following files and subdirectories to the 
product installation directory, by default:

/opt/Progress/DataDirect/ODBC_80_64bit:

odbc.csh                         Setup script for C shell
odbc.ini                         Sample odbc.ini file
odbcinst.ini                     Sample odbcinst.ini file
odbc.sh                          Setup script for Bourne shell
DDODBC.LIC                       DataDirect license file
fixes.txt                        List of fixes since last release
license.txt                      Progress DataDirect license agreement

/bin:
ddtestlib                        Test application to check that required 
                                 libraries are present and loadable

/help: 
sqlserverwp_connect.txt          Help text for the SQL Server WP driver 
                                 SQLDriverConnect dialog 
/help/SQLServerHelp:
index.html                       HTML help system entry file
*.*                              Support folders for the HTML help system

/include:
odbcinst.h                       Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h

/lib:
ddsqls28.so                      SQL Server WP driver  
ddtrc28.so                       Progress DataDirect trace library
libivcurl28.so                   Library used for HTTP connections [.a on AIX]
libddicu28.so                    Unicode conversion tables  [.a on AIX]
libddmback.so                    SQLDriverConnect Motif library 
libddmbackw.so                   SQLDriverConnect Motif library [.a on AIX]
libddssl28.so	                 SSL support file (1.0.2r) [.a on AIX]
libodbc.so                       ODBC Driver Manager [.a on AIX]
libodbcinst.so                   ODBC Installer [.a on AIX]
odbc.so                          ODBC Driver Manager (dynamically loadable) 
                                 [AIX only]
odbccurs.so                      ODBC Cursor library 
odbcinst.so                      ODBC Installer (dynamically loadable) 
                                 [AIX only]
vscnctdlg.so                     ODBC library for Motif operations

/OpenSSL:
latest/libddssl28.so             SSL support file (OpenSSL library 
                                 version 1.0.2r) [.a on AIX] 
1.0.2d/libivssl28.so             SSL support file (OpenSSL library 
                                 version 1.0.2d) [.a on AIX] 

/locale/en_US/LC_MESSAGES:
ddmbackw.mo                      Motif library message file
ddmbackw.po                      Motif library message source
ddsqls28.mo                      SQL Server WP driver message file
ddsqls28.po                      SQL Server WP driver message file source
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source

/notices:
ODBC for SQL Server 
v8.0 notices.txt	             Third-party vendor license agreements	

/readmes:
ODBC for SQL Server
v8.0 readme.txt	                 This file

/samples:
/bulk/bulk                       Bulk application
/bulk/bulk.c                     Bulk example source
/bulk/bulk.mak                   Bulk example make file
/bulk/bulk.txt                   Bulk example description

/bulkstrm/bulk.cpp        	 Bulk streaming example source
/bulkstrm/bulk.hpp        	 Bulk streaming example header
/bulkstrm/bulkstrm               Bulk streaming example application
/bulkstrm/bulkstrm.txt           Bulk streaming example description
/bulkstrm/main.cpp               Bulk streaming example source
/bulkstrm/msgprintf.hpp          Bulk streaming example header
/bulkstrm/streambulk.mak         Bulk streaming example make file

/example/example                 Example application
/example/example.c               Example source
/example/example.h               Example header
/example/example.mak             Example make file
/example/example64.txt           Example description

/tools:
ddextu                           License Extender utility
ddprocinfo                       Processor Information utility	
   
   
   
~~~~~~~~~~~~~~
April 3, 2019

End of README