HDPODBCREADME.TXT
     Progress(R) DataDirect(R) Hybrid Data Pipeline
     Hybrid Data Pipeline Driver for ODBC
     Release 4.1
     April 2017

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

***********************************************************************

IMPORTANT: On Windows, 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

Changes for Release 4.1
Product Features
Installation Directory
Disk Space Requirements
Notes, Known Problems, and Restrictions
Documentation
Installed Files for the Driver on Windows
Installed Files for the Driver on Linux
Third-Party Acknowledgments


     Changes for Release 4.1

OpenSSL
-------
The default OpenSSL library has been updated to 1.0.2k, which fixes the 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)

OpenSSL 1.0.2k addresses vulnerabilities resolved by earlier versions of the
library. For more information on OpenSSL vulnerabilities resolved by this
upgrade, refer to OpenSSL announcements:
https://www.openssl.org/news/openssl-1.0.2-notes.html

Platform Certifications
-----------------------
The Hybrid Data Pipeline Driver for ODBC has been certified against the
following platforms.

* CentOS Linux 4.x, 5.x, 6.x, and 7.x

* Debian Linux 7.11, 8.5

* Oracle Linux 4.x, 5.x, 6.x, and 7.x

* Ubuntu Linux 14.04, 16.04

Windows Server 2003 Deprecation
-------------------------------
Support for Windows Server 2003 has been deprecated.


     Product Features

Progress DataDirect Hybrid Data Pipeline is a data access platform that provides
simple, secure access to cloud and on-premises data sources, such as RDBMS, Big
Data, and NoSQL. The ODBC driver is one of four primary components of the Hybrid
Data Pipeline. The ODBC driver enables ODBC applications to communicate to a data
source through the Hybrid Data Pipeline server. The ODBC driver is installed
separately.


     Installation Directory

The default installation directory for Hybrid Data Pipeline for ODBC driver is:

* 32-bit Windows machine
  C:\Program Files\Progress (x86)\DataDirect\Hybrid_Data_Pipeline_for_ODBC

* 64-bit Windows machine
  C:\Program Files\Progress\DataDirect\Hybrid_Data_Pipeline_for_ODBC

* On a UNIX machine:
  /opt/Progress/DataDirect/Hybrid_Data_Pipeline_for_ODBC
  NOTE: If you do not have access to "/opt", your user's directory will take the
  place of this directory.

     Disk Space Requirements

32-bit driver: The following available disk space requirement assumes a 
full installation of the driver on either a 32-bit or 64-bit machine.

* 132 MB


     Notes, Known Problems, and Restrictions

The following are notes, known problems, or restrictions with 
the Hybrid Data Pipeline for ODBC driver.

ODBC.INI
--------
* The default ODBC.INI generated by the installer is missing required
  entries for Service=, PortNumber=, and HybridDataPipelineDataSource=.

Installation
------------
* Console mode installation is supported only on UNIX.

Installing and Removing Default Data Sources (on Windows)
---------------------------------------------------------
When you first install a driver, you are given the option to install a 
default data source for that driver. We recommend that you install 
default data sources when you first install the drivers. If you do not 
install the default data source at this time, you will be unable to 
install a default data source for this driver later. To install a 
default data source for a driver after the initial installation, you 
must uninstall the driver and then reinstall it.

Salesforce.com, Force.com, and Database.com
-------------------------------------------
* SQLGetDescField(SQL_DESC_NAME) and SQLColAttributes(SQL_DESC_NAME) 
  do not return a column alias. The column name is always returned.

* GetInfos
  - Several SQLGetInfo calls for max length, max number return unknown 
    instead of the maximum length or maximum count.
  - TEXTAREA data type takes a create parameter max length. That is  
    not reported in the TypeInfo.

* Binary data (SQL_C_BINARY) inserted into character columns 
  (SQL_CHAR, SQL_VARCHAR, SQL_LONGVARCHAR) is not inserted correctly.

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 Hybrid Data
Pipeline drivers with an IIS server, refer to KnowledgeBase document
number 4274 on the Progress DataDirect web site:

http://knowledgebase.datadirect.com


     Documentation

Hybrid Data Pipeline documentation consists of the following guides and readmes.

* PROGRESS DATADIRECT HYBRID DATA PIPELINE INSTALLATION GUIDE
  Available online at
  https://documentation.progress.com/output/DataDirect/hybridpipeinstall

* PROGRESS DATADIRECT HYBRID DATA PIPELINE QUICK START
  Available online at
  https://documentation.progress.com/output/DataDirect/hybridpipestart

* PROGRESS DATADIRECT HYBRID DATA PIPELINE USER'S GUIDE
  Available online at
  https://documentation.progress.com/output/DataDirect/hybridpipeline

* The Hybrid Data Pipeline readme file: hdpreadme.txt
  Installed file and available online at
  https://documentation.progress.com/output/DataDirect/hdpreadmes/hdpreadme.htm

* The On-Premise Connector readme file: hdpopcreadme.txt
  Installed file and available online at
  https://documentation.progress.com/output/DataDirect/hdpreadmes/hdpopcreadme.htm

* The JDBC Driver readme file: hdpjdbcreadme.txt
  Installed file and available online at
  https://documentation.progress.com/output/DataDirect/hdpreadmes/hdpjdbcreadme.htm

* The ODBC Driver readme file: hdpodbcreadme.txt
  Installed file and available online at
  https://documentation.progress.com/output/DataDirect/hdpreadmes/hdpodbcreadme.htm

* The OpenAccess Server readme file: hdpoaserverreadme.txt
  Installed file and available online at
  https://documentation.progress.com/output/DataDirect/hdpreadmes/hdpoaserverreadme.htm


     Installed Files for the Driver on Windows

The installer creates the following directories and files in the product 
installation directory (as determined by the user), represented by 
INSTALL_DIR. Your installation may vary from this list depending on your
platform.

The prefix for the 32-bit driver file name is iv. The prefix for the 
64-bit driver file name is dd. For example, the 32-bit  driver file
name is ivhybridnn.dll, where nn is the revision number of the driver.

The installer copies the following files to the Windows system 
directory:

CTL3D32.DLL           Visual C Runtime Library
MFC42.DLL             Visual C Runtime Library
IVTRC27.DLL           DataDirect trace library

The installer copies the following files and subdirectories to  
INSTALL_DIR:

NOTICES.TXT           Third-party vendor license agreements
HDPODBCREADME.TXT     This file

\DRIVERS:

Resource library file names end in R.

IVICU27.DLL           Unicode conversion tables
IVHYBRID01.DLL        Hybrid Data Pipeline for ODBC driver
IVHYBRID01R.DLL       Driver Resource DLL


\HELP: 
INDEX.HTML            HTML help system entry file
*.*                   Support files for the HTML help system
\*.*                  Support folders for the HTML help system

\INSTALL:
DRIVER-HYBRID.PROPERTIES
INSTALLED.PROPERTIES
TAILOR.MANIFEST

\INSTALL\LOGS
*.*                    Log files
  

The following file and subdirectory are required to connect
in this release:

\SSLCERTIFICATES:
SSLCERTIFICATES.PEM    SSL CA Certificate

\UNINSTALL:
*.*                    Files used to uninstall the product

\JRE
*.*                    A Java Runtime Environment used by the installer        
                       and uninstaller

\%USERPROFILE%: 
HDP_ODBC_INSTALL_CONSOLE.LOG  
                       Installation log file


     Installed Files for the Driver on Linux/UNIX

The prefix for the 32-bit driver file name is iv. The prefix for the 
64-bit driver file name is dd. The driver file names are lowercase 
and the extension is .so, the standard form for a shared object. 
For example, the 32-bit driver file name is ivhdpnn.so, where nn is
the revision number of the driver.

The following files and subdirectories are copied to the 
product installation directory:

notices.txt           Third-party vendor license agreement
odbc.ini              Sample odbc.ini file
odbcinst.ini          Sample odbcinst.ini file
hdpodbcreadme.txt     This file


/include:

*.*                   Include files


/lib:

In this list, zz represents the file extension (either .so or .sl, 
depending on the platform):

ivhybrid01.zz         Hybrid Data Pipeline for ODBC driver
ivtrc27.zz            DataDirect trace library
libivicu27.so         Unicode conversion tables
libodbc.so            ODBC Driver Manager
libodbcinst.so        ODBC Driver Installer
odbccurs.so           ODBC Cursor library
libivmback.so         SQLDriverConnect Motif library
libivmbackw.so        SQLDriverConnect Motif library
vscnctdlg.so          ODBC library for Motif operations


/locale/en_US/LC_MESSAGES:

ivhybrid01.mo         Hybrid Data Pipeline for ODBC driver message file
ivhybrid01.po         Hybrid Data Pipeline for ODBC driver message source
odbc.m                ODBC Driver Manager message file
odbc.po               ODBC Driver Manager message source 


The following file and subdirectory are required to connect in this
release:

/sslcertificates:

sslcertificates.pem   SSL CA Certificate

/uninstall:

uninstall_Progress_DataDirect_Hybrid_DataPipeline_for_ODBC_-_32_bit*.exe
                      File to uninstall the driver


     Third-Party Acknowledgments

Refer to the following Web page:
https://www.progress.com/legal/hybridpipe-third-party


April 2017
~~~~~~~~~~
End of README