README
     Progress (R) DataDirect (R)
	 
     Progress(R) DataDirect(R) for ODBC for
     Amazon Redshift(TM) Wire Protocol Driver

     Windows Platforms (32- and 64-bit)
     Release 8.0.0
     February 2, 2018


***********************************************************************
Copyright (C) 1990-2018 Progress Software Corporation and/or its 
subsidiaries or affiliates. All Rights Reserved. 
***********************************************************************
This README file contains information for Progress(R) DataDirect(R) 
for ODBC for Amazon Redshift(TM) Wire Protocol Driver. 

This README file contains information not included in the PROGRESS
DATADIRECT(R) FOR ODBC FOR AMAZON REDSHIFT WIRE PROTOCOL DRIVER
USER'S GUIDE AND REFERENCE.

IMPORTANT: You must have the Microsoft Data Access Components (MDAC) 
installed to use this product.
 
* For 32-bit Windows systems, version 2.6 or higher is required.
* For 64-bit Windows systems, version 2.8 or higher is required.

Depending on the version of your Windows operating system, these 
components may already be installed. You can download a utility that 
determines whether MDAC is installed and its version from the following 
Microsoft site:

http://msdn.microsoft.com/en-us/data/aa937730.aspx

You can also download MDAC from the same site. 

CONTENTS

Installation Directory
Changes Since 8.0.0 GA 
Changes for 8.0.0 GA 
Driver WorkAround Options
Notes, Known Problems, and Restrictions
Documentation
Installed Files for the 32-bit Driver
Installed Files for the 64-bit Driver
Documentation Third-Party Acknowledgements 


	Installation Directory

* The default installation directory for the 32-bit driver on a 64-bit system is:

  C:\Program Files (86)\Progress\DataDirect\ODBC_80

* The default installation directory for all other installations is:

  C:\Program Files\Progress\DataDirect\ODBC_80

  
    Changes Since 8.0.0
	
SSL Enhancement (1.0.2n) 
------------------------
The default OpenSSL library version has been updated to 1.0.2n, which 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)
 
This upgrade is available starting in build 08.01.0147 of the OpenSSL library 
file.  
 
Version 1.0.2n 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.0 GA 

Certifications 
--------------
* Certified with Windows Server 2016 (driver version 07.16.0114 (B0316, U0209))

Visual Studio 2015 Upgrade
--------------------------
The driver is now compiled using Visual Studio 2015 for improved security. 

HTTP Proxy Support
------------------	
The driver has been enhanced to support connecting to a proxy server through
an HTTP connection. HTTP proxy support is configurable with the new Proxy Host,
Proxy Mode, Proxy Password, Proxy Port, and Proxy User connection options.

TimestampTZ Data Type
---------------------
The driver has been enhanced to support the TimestampTZ data type.

Fetch TSWTZ as Timestamp Connection Option
------------------------------------------
The new Fetch TSWTZ as Timestamp option allows you to determine whether the 
driver returns column values with the TimestampTZ data type as the
ODBC data type SQL_TYPE_TIMESTAMP or SQL_VARCHAR. 

ODBC Functions
--------------
The driver has been enhanced to support the HOUR, MINUTE, MONTH, QUARTER, 
SECOND, WEEK, and YEAR ODBC functions for improved support of third-party 
applications such as Tableau.  

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

The default OpenSSL library version has been updated to 1.0.2k, which fixes the 
following security vulnerabilities:
 * Truncated packet could crash via OOB read (CVE-2017-3731)
 * BN_mod_exp may produce incorrect results on x86_64 (CVE-2017-3732)
 * Montgomery multiplication may produce incorrect results (CVE-2016-7055)


    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 

126 Error When Modifying Data Sources on Windows 10
---------------------------------------------------
You may receive a 126 error when adding or configuring a data source stored
on a network location. This is caused by the settings of the User Account 
Control (UAC) security feature on Windows 10. To work around this issue:

Important: Implementing this fix disables security safeguards that are designed
to protect your machine. Before starting, refer to the following Microsoft 
documentation for potential risks associated with disabling the UAC feature:  
http://windows.microsoft.com/en-us/
windows/what-are-user-account-control-settings

1.  From the Start menu, type regedit in the search field; then, select regedit
    from the results list. The Registry Editor window opens. 

2.  Navigate to the following registry subkey: 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

3.  Right-click on the subkey; then, select New > DWORD Value. 

4.  Rename the new value EnableLinkedConnections. 

5.  Right-click EnableLinkedConnections, and then click Modify. The Edit DWORD 
    Value window opens. 

6.  In the Value data field, type 1. Click OK. 

7.  Close the Registry Editor; then, restart your computer. 	

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
  
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. 
  
     Documentation	 	 

THE PROGRESS DATADIRECT FOR ODBC FOR AMAZON REDSHIFT WIRE PROTOCOL DRIVER
USER'S GUIDE AND REFERENCE 
----------------------------------------------------------------------- 
The User's Guide and Reference is provided in PDF and HTML versions. Both 
versions are installed in the CassandraHelp subdirectory of your product 
installation directory. You can access the HTML help by opening the index.html
file or by clicking the Help button on the driver setup dialog. The PDF 
version, which you can view using Adobe Reader, can be viewed by opening the 
cassandraodbcuser.pdf file.

NOTE: To download Adobe Reader, visit the Adobe Web site at 
http://www.adobe.com.


Installed Files for 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:

For the 32-bit driver on 64-bit machines:
  C:\Program Files (x86)\Progress\DataDirect\ODBC_80\:

For all other installations:
  C:\Program Files\Progress\DataDirect\ODBC_80\:

fixes.txt             List of fixes since last release
license.txt           End User License Agreement


\drivers:
ivcurl28.dll            Library used for HTTP connections 
ivicu28.dll		Unicode conversion tables
ivrsft28.dll		Amazon Redshift Wire Protocol driver
ivrsft28r.dll		Amazon Redshift Wire Protocol driver
			resource file
IVODBC.LIC		DataDirect License File
ivssl28.dll		SSL support file (OpenSSL library file, 
                        version 1.0.2n)
ivtrc28.dll		Progress DataDirect trace library
qesqlext.h		Header file for DataDirect-specific ODBC Definitions

OpenSSL\latest\ivssl28.dll SSL support file 
                           (OpenSSL library file, version 1.0.2n)

						   
\help\RedshiftHelp: 
index.html              HTML help system entry file
\*.*                    Support folders for the HTML help system
redshiftodbcuser.pdf    PDF copy of the User's Guide and Reference


\jre
*.*		        Files associated with the Amazon Redshift WP driver


\NOTICES:
ODBC for Amazon Redshift
v8.0 notices.txt	Third-party vendor license agreements


\READMES:
ODBC for Amazon Redshift
v8.0 readme.txt	This file

\samples:
\bulk\bulk.c        		  Bulk example source
\bulk\bulk.exe      		  Bulk application
\bulk\bulk.mak      		  Bulk example make file
\bulk\bulk.sln      		  Bulk example solution file
\bulk\bulk.vcproj   		  Bulk example project file
\bulk\ddlogging.properties        Log configuration file for
				  the Amazon Redshift WP driver
                       
\bulkstrm\bulk.cpp                Bulk streaming example source
\bulkstrm\bulk.hpp                Bulk streaming example header
\bulkstrm\bulk.rc                 Bulk streaming example resource file
\bulkstrm\bulkstreaming.sln       Bulk streaming example solution file
\bulkstrm\bulkstreaming.vcproj    Bulk streaming example project file
\bulkstrm\bulkstrm.exe            Bulk streaming example application
\bulkstrm\bulkstrm.txt   	  Bulk streaming description
\bulkstrm\ddlogging.properties    Log configuration file for the 
				  Amazon Redshift WP driver
\bulkstrm\msgprintf.hpp           Bulk streaming example header file
\bulkstrm\ProgressDataDirect.bmp
\bulkstrm\ProgressDataDirect.ico
\bulkstrm\winmain.cpp             Bulk streaming example source file

\example\ddlogging.properties     Log configuration file for the 
                                  Amazon Redshift WP driver
\example\example.c         	  Example source
\example\Example.exe       	  Example application
\example\example.h         	  Example header
\example\Example.mak       	  Example make file
\example\Example.sln       	  Example solution file
\example\Example.vcproj    	  Example project file
\example\example.txt       	  Example description


\Tableau:
DataDirect Redshift.tdc           Tableau data source file 


\tools:
ivextwin.exe			  License Extender utility
ivprocinfo.exe			  Processor Information utility
DSNCOnverterSIL.exe		  Data Source Converter utility
makelic.exe			  License management file
XMLP.exe			  A GUI demo tool that persists a result
                                  set to an XML data file
						
\uninstall\*.*			  Files used to uninstall the product
            

			
Installed Files for the 64-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:

   C:\Program Files\Progress\DataDirect\ODBC_80\:

fixes.txt             List of fixes since last release
license.txt           End User License Agreement


\drivers:
ddcurl28.dll            Library used for HTTP connections 
ddicu28.dll		Unicode conversion tables
ddrsft28.dll		Amazon Redshift WP driver
ddrsft28r.dll		Amazon Redshift WP driver
			resource file
DDODBC.LIC		DataDirect License File
ddssl28.dll		SSL support file (OpenSSL library file,
                        version 1.0.2n)
ddtrc28.dll		Progress DataDirect trace library
qesqlext.h		Header file for DataDirect-specific ODBC Definitions

OpenSSL\latest\ddssl28.dll SSL support file 
                           (OpenSSL library file, version 1.0.2n)

						   
\help\RedshiftHelp: 
index.html              HTML help system entry file
\*.*                    Support folders for the HTML help system
redshiftodbcuser.pdf    PDF copy of the User's Guide and Reference


\jre
*.*			Files associated with the Amazon Redshift WP driver


\NOTICES:
ODBC for Amazon Redshift
v8.0 notices.txt	Third-party vendor license agreements


\READMES:
ODBC for Amazon Redshift
v8.0 readme.txt	This file


\samples:
\bulk\bulk.c        		  Bulk example source
\bulk\bulk.exe      		  Bulk application
\bulk\bulk.mak      		  Bulk example make file
\bulk\bulk.sln      		  Bulk example solution file
\bulk\bulk.vcproj   		  Bulk example project file
\bulk\ddlogging.properties        Log configuration file for the 
				  Amazon Redshift WP driver
                       
\bulkstrm\bulk.cpp                Bulk streaming example source
\bulkstrm\bulk.hpp                Bulk streaming example header
\bulkstrm\bulk.rc                 Bulk streaming example resource file
\bulkstrm\bulkstreaming.sln       Bulk streaming example solution file
\bulkstrm\bulkstreaming.vcproj    Bulk streaming example project file
\bulkstrm\bulkstrm.exe            Bulk streaming example application
\bulkstrm\bulkstrm.txt 		  Bulk streaming description
\bulkstrm\ddlogging.properties    Log configuration file for the 
				  Amazon Redshift WP driver
\bulkstrm\msgprintf.hpp           Bulk streaming example header file
\bulkstrm\ProgressDataDirect.bmp
\bulkstrm\ProgressDataDirect.ico
\bulkstrm\winmain.cpp             Bulk streaming example source file

\example\ddlogging.properties     Log configuration file for the 
				  Amazon Redshift WP driver
\example\example.c         	  Example source
\example\Example.exe       	  Example application
\example\example.h         	  Example header
\example\Example.mak       	  Example make file
\example\Example.sln       	  Example solution file
\example\example.txt       	  Example description
\example\Example.vcproj    	  Example project file


\Tableau:
DataDirect Redshift.tdc           Tableau data source file 


\tools:
ddextwin.exe			  License Extender utility
ddprocinfo.exe			  Processor Information utility
DSNConverterSIL.exe		  Data Source Converter utility
makelic.exe			  License management file
XMLP.EXE			  A GUI demo tool that persists a result
                                  set to an XML data file
	
	
\uninstall\*.*			  Files used to uninstall the product



    Documentation Third-party Acknowledgements 
	
Copyright (c) 1987-2017 Progress Software Corporation and/or one of its 
subsidiaries or affiliates. All rights reserved.

One or more product(s) in the Progress DataDirect for ODBC for Amazon Redshift
v8.0 release include(s) third-party components covered by licenses that require
that the following documentation notices be provided.  If changes in 
third-party components occurred for the current release of the Product(s), the 
following Third-Party Acknowledgements may contain notice updates to any 
earlier versions provided in documentation or README file. 

Progress DataDirect for ODBC for Amazon Redshift v8.0 incorporates ICU v4.2.1 
from International Business Machines Corporation.  Such technology is subject 
to the following terms and conditions:  ICU License - ICU 1.8.1 and later ICU 
License - ICU 1.8.1 and later COPYRIGHT AND PERMISSION NOTICE. Copyright (c) 
1995-2010 International Business Machines Corporation and others. All rights 
reserved. Permission is hereby granted, free of charge, to any person obtaining
a copy of this software and associated documentation files (the "Software"), to
deal in the Software without restriction, including without limitation the 
rights to use, copy, modify, merge, publish, distribute, and/or sell copies of
the Software, and to permit persons to whom the Software is furnished to do so,
provided that the above copyright notice(s) and this permission notice appear 
in all copies of the Software and that both the above copyright notice(s) and 
this permission notice appear in supporting documentation. THE SOFTWARE IS 
PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING 
BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR 
PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE 
COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, 
OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER 
RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, 
NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE 
USE OR PERFORMANCE OF THIS SOFTWARE. Except as contained in this notice, the 
name of a copyright holder shall not be used in advertising or otherwise to 
promote the sale, use or other dealings in this Software without prior written 
authorization of the copyright holder.  All trademarks and registered 
trademarks mentioned herein are the property of their respective owners.

Progress DataDirect for ODBC for Amazon Redshift v8.0 incorporates OpenSSL 
toolkit v1.0.2_x from The OpenSSL Project. Such technology is subject to the 
following terms and conditions:  LICENSE ISSUES ============== The OpenSSL 
toolkit stays under a dual license, i.e. both the conditions of the OpenSSL 
License and the original SSLeay license apply to the toolkit. See below for 
the actual license texts. Actually both licenses are BSD-style Open Source 
licenses. In case of any license issues related to OpenSSL please contact 
openssl-core@openssl.org.
OpenSSL License --------------- 
Copyright (c) 1998-2011 The OpenSSL Project.  All rights reserved.
Redistribution and use in source and binary forms, with or without 
modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice, this
   list of conditions and the following disclaimer. 
2. Redistributions in binary form must reproduce the above copyright notice, 
   this list of conditions and the following disclaimer in the documentation 
   and/or other materials provided with the distribution.
3. All advertising materials mentioning features or use of this software must 
   display the following acknowledgment: "This product includes software 
   developed by the OpenSSL Project for use in the OpenSSL Toolkit. 
   (http://www.openssl.org/)"  
4. The names "OpenSSL Toolkit" and "OpenSSL Project" must not be used to 
   endorse or promote products derived from this software without prior 
   written permission. For written permission, please contact 
   openssl-core@openssl.org.	
5. Products derived from this software may not be called "OpenSSL" nor may 
   "OpenSSL" appear in their names without prior written permission of the 
   OpenSSL Project.	
6. Redistributions of any form whatsoever must retain the following 
   acknowledgment: "This product includes software developed by the OpenSSL 
   Project for use in the OpenSSL Toolkit (http://www.openssl.org/)"	
THIS SOFTWARE IS PROVIDED BY THE OpenSSL PROJECT ``AS IS'' AND ANY EXPRESSED OR
IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF 
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO 
EVENT SHALL THE OpenSSL PROJECT OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, 
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY 
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, 
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.	
====================================================================
This product includes cryptographic software written by Eric Young 
(eay@cryptsoft.com).  This product includes software written by Tim Hudson 
(tjh@cryptsoft.com). 
Original SSLeay License  ----------------------- Copyright (C) 1995-1998 
Eric Young (eay@cryptsoft.com) All rights reserved.
This package is an SSL implementation written by Eric Young 
(eay@cryptsoft.com). The implementation was written so as to conform with 
Netscapes SSL. This library is free for commercial and non-commercial use as 
long as the following conditions are aheared to.  The following conditions 
apply to all code found in this distribution, be it the RC4, RSA, lhash, DES, 
etc., code; not just the SSL code.  The SSL documentation included with this 
distribution is covered by the same copyright terms except that the holder is
Tim Hudson (tjh@cryptsoft.com). Copyright remains Eric Young's, and as such 
any Copyright notices in the code are not to be removed. If this package is 
used in a product, Eric Young should be given attribution as the author of the
parts of the library used. This can be in the form of a textual message at 
program startup or in documentation (online or textual) provided with the 
package. Redistribution and use in source and binary forms, with or without 
modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the copyright notice, this list
   of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, 
   this list of conditions and the following disclaimer in the documentation 
   and/or other materials provided with the distribution.  
3. All advertising materials mentioning features or use of this software must 
   display the following acknowledgement: "This product includes cryptographic
   software written by Eric Young (eay@cryptsoft.com)" The word 'cryptographic'
   can be left out if the routines from the library being used are not 
   cryptographic related :-). 
4. If you include any Windows specific code (or a derivative thereof) from the
   apps directory (application code) you must include an acknowledgement: "This
   product includes software written by Tim Hudson (tjh@cryptsoft.com)"
THIS SOFTWARE IS PROVIDED BY ERIC YOUNG ``AS IS'' AND ANY EXPRESS OR IMPLIED 
WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF 
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO 
EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, 
INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 
LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR 
PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF 
LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
The licence and distribution terms for any publically available version or 
derivative of this code cannot be changed.  i.e. this code cannot simply be 
copied and put under another distribution licence [including the GNU Public 
Licence.]

	
~~~~~~~~~~~~~~
February 2, 2018
End of README.TXT