Progress DataDirect OpenAccessTM SDK 8

Progress DataDirectTMOpenAccess SDK 8.1Upgrade NotesSeptember 2016

ContentsOPENACCESS SDK VERSION 8.1 . 5HIGHLIGHTS . 5OpenAccess SDK SQL Engine and IP SDK . 5OpenAccess SDK Server . 5OpenAccess SDK Client for JDBC . 5OpenAccess SDK Client for ODBC . 5OpenAccess SDK Client for ADO.NET. 5UPGRADING FROM OPENACCESS SDK 8.0 TO 8.1 . 6Backward Compatibility . 6Documentation . 6License Keys . 6C/C IP for OpenAccess SDK SQL Engine . 6Java IP for OpenAccess SDK SQL Engine . 7.NET IP for OpenAccess SDK SQL Engine. 7C SQL IP . 8Java SQL IP . 8Branding and Distribution . 8File Name Changes . 9Configuration Changes . 9OPENACCESS SDK VERSION 8.0 . 10HIGHLIGHTS . 10OpenAccess SDK SQL Engine and IP SDK . 10OpenAccess SDK Server . 10OpenAccess SDK Client for JDBC . 10OpenAccess SDK Client for ODBC . 10OpenAccess SDK Client for ADO . 10OpenAccess SDK Client for ADO.NET. 10UPGRADING FROM OPENACCESS SDK 7.2 TO 8.0 . 10Documentation . 11License Keys . 11C/C IP for OpenAccess SDK SQL Engine . 11Java IP for OpenAccess SDK SQL Engine . 12.NET IP for OpenAccess SDK SQL Engine. 13C SQL IP . 14Java SQL IP . 15Branding and Distribution . 15File Name Changes . 15Configuration Changes . 15OPENACCESS SDK VERSION 7.2.0 . 16HIGHLIGHTS . 16OpenAccess SDK SQL Engine and IP SDK . 16OpenAccess SDK Server . 16OpenAccess SDK Client for JDBC . 16OpenAccess SDK Client for ODBC . 16OpenAccess SDK Client for ADO . 16OpenAccess SDK Client for ADO.NET. 16UPGRADING FROM OPENACCESS SDK 7.0.1 TO 7.2.0 . 17Documentation . 17License Keys . 17C/C IP for OpenAccess SDK SQL Engine . 17Java IP for OpenAccess SDK SQL Engine . 17Progress Software Corporation September 20162

.Net IP for OpenAccess SDK SQL Engine . 18Branding and Distribution . 18File Name Changes . 18Configuration Changes . 18OPENACCESS SDK VERSION 7.0.1. 19HIGHLIGHTS . 19OpenAccess SDK SQL Engine and IP SDK . 19OpenAccess SDK Server . 19OpenAccess SDK Client for JDBC . 19OpenAccess SDK Client for ODBC . 19OpenAccess SDK Client for ADO . 19OpenAccess SDK Client for ADO.NET . 19UPGRADING FROM OPENACCESS SDK 7.0 TO 7.0.1. 20Documentation . 20License Keys . 20Branding and Distribution . 20File Name Changes . 20Configuration Changes . 20OPENACCESS SDK VERSION 7.0. 20HIGHLIGHTS . 20OpenAccess SDK SQL Engine and IP SDK . 20OpenAccess SDK Server . 21OpenAccess SDK Client for JDBC . 21OpenAccess SDK Client for ODBC . 21OpenAccess SDK Client for ADO . 21OpenAccess SDK Client for ADO.NET . 21UPGRADING FROM OPENACCESS SDK 6.0 SP3 TO 7.0 . 22SSL Compatibility . 22License Keys . 22C/C IP for OpenAccess SDK SQL Engine . 22C/C IP for Third-party SQL Engine . 23Java IP for OpenAccess SDK SQL Engine . 23Java IP for Third-party SQL Engine. 24.NET IP for OpenAccess SDK SQL Engine . 24Branding and Distribution . 25OPENACCESS SDK VERSION 6.0 SP3 . 27HIGHLIGHTS . 27UPGRADING FROM OPENACCESS SDK 6.0 SP2 TO 6.0 SP3 . 27Documentation . 28License Keys . 28C/C IP for OpenAccess SDK SQL Engine . 28C/C IP for Third-party SQL Engine . 28Java IP for OpenAccess SDK SQL Engine . 28Java IP for Third-party SQL Engine. 28.NET IP for OpenAccess SDK SQL Engine . 28Branding and Distribution . 28UPGRADING FROM OPENACCESS SDK 6.0 SP1 TO 6.0 SP3 . 29Documentation . 29License Keys . 29C/C IP for OpenAccess SDK SQL Engine . 29C/C IP for Third-party SQL Engine . 29Java IP for OpenAccess SDK SQL Engine . 30Progress Software Corporation September 20163

Java IP for Third-party SQL Engine. 30.NET IP for OpenAccess SDK SQL Engine . 30Branding and Distribution . 30OPENACCESS SDK VERSION 6.0 SP1 . 33HIGHLIGHTS . 33UPGRADING FROM OPENACCESS SDK 6.0 TO 6.0 SP1 . 34Documentation . 34License Keys . 34Configuration Changes . 35C/C IP for OpenAccess SDK SQL Engine . 37Java IP for OpenAccess SDK SQL Engine . 37.NET IP for OpenAccess SDK SQL Engine . 38Branding and Distribution . 38OPENACCESS SDK VERSION 6.0. 39HIGHLIGHTS . 39UPGRADING FROM OPENACCESS SDK 5.6 TO 6.0 . 39Configuration Changes . 40C/C IP for OpenAccess SDK SQL Engine . 40C/C IP for Third-party SQL Engine (previously referred to as SQL IP) . 42Java IP for OpenAccess SDK SQL Engine . 44Java IP for Third-party SQL engine (previously referred to as SQL IP) . 47.NET IP for OpenAccess SDK SQL engine. 48Progress Software Corporation September 20164

OpenAccess SDK Version 8.1HighlightsThis section highlights what’s new in OpenAccess SDK 8.1:OpenAccess SDK SQL Engine and IP SDK Support for RIGHT OUTER JOIN operations Improved support for nested join queries Improved performance with indexed disk cache for nested query results Improved calculation of precision of the scalar function result, based on precision ofinput arguments Support for configurable behavior to enforce an integrity constraint check when nullvalues are specified in non-nullable result columns with theIP INFO VALIDATE NULL CONSTRAINT ipGetinfo optionOpenAccess SDK Server Support for service configurable option, ServiceNetworkBufferSize, to specify networkprotocol buffer size Support for service configurable option, ServiceSSLVersions, to specify the version ofcryptoprotocol to be used for encryption, when SSL is enabled Upgrade of OpenSSL library to 1.0.2hOpenAccess SDK Client for JDBC Support for JDBC 4.0 specification Support for the CryptoProtocolVersion connection option that specifies the version of theSSL standard used for encryption, whenever SSL is enabledOpenAccess SDK Client for ODBC Distribution of the sample Tableau TDC file with the OpenAccess ODBC client as astandard component Support for the CryptoProtocolVersion connection option that specifies the version of theSSL standard that is used for encryption, whenever SSL is enabled Upgrade of OpenSSL library to 1.0.2hOpenAccess SDK Client for ADO.NET Support for 64-bit row fetch Support for public/global IP address for client identification Support for the CryptoProtocolVersion connection option that specifies the version of theSSL standard that is used for encryption, whenever SSL is enabled Inclusion of branding tool as part of installationProgress Software Corporation September 20165

Support for Visual Studio 2013 and 2015Dropped support for Visual Studio 2008 and 2010Support for .NET Framework 4.5 and .NET Framework 4.6Dropped support for .NET Framework 2.0, 3.0, 3.5, and 4.0Upgrading from OpenAccess SDK 8.0 to 8.1This section provides details for upgrading from the OpenAccess SDK 8.0 release to the 8.1 release.If you are upgrading from an earlier version, first refer to the “Upgrading from OpenAccess SDK7.2 to 8.0” section of this document and then return here.Backward Compatibility OpenAccess SDK 8.1 Servers are backward compatible with OpenAccess SDK Client 8.0 OpenAccess SDK 8.1 Clients are compatible with OpenAccess SDK Server 8.0The following sections detail the changes for each of the different parts of the product.DocumentationNew documentation is being released for OpenAccess SDK 8.1. All changes to the OpenAccess SDKVersion 8.0 are described in the fixes component .txt, or this document.License KeysOpenAccess SDK Version 8.1 requires new keys that are different from the keys for OpenAccessSDK 8.0 and earlier. Please contact Progress customer support to obtain new keys.C/C IP for OpenAccess SDK SQL EngineRefer to the OpenAccess SDK SQL Engine Programmer’s Reference for C/C for details on settingup the environment to code your IP. Once you have set up the environment, copy your IP code to thenew folder and make changes to the IP APIs and DAM/DAMEX APIs as described in the followingsections.IP API ChangesFollowing is the enhancement for OAIP schema introduced in 8.1: The pSearchObj parameter is now available even for the DAMOBJ TYPE SCHEMAschema type. The IP can use this information or pass the pSearchObj to the OpenAccessSDK SQL engine when calling the dam add damobj xxxxx functions. It is NULL if nosearch criteria is specified.DAM API changes Enhanced the dam getInfo API to retrieve the client version with theDAM INFO CLIENT PRODUCT VERSION info type. Enhanced the dam getInfo API to retrieve the cipher suite and cryptoprotocol versionbeing used to connect to the OpenAccess SDK Server with the following info types: DAM INFO SESSION CIPHER SUITE DAM INFO SESSION CRYPTO PROTOCOL VERSIONProgress Software Corporation September 20166

Java IP for OpenAccess SDK SQL EngineRefer to the OpenAccess SDK SQL Engine Programmer’s Reference for Java for details on settingup the environment to code your IP. Once you have set up the environment, copy your IP code to thenew folder and make changes to the IP APIs and DAM/DAMEX APIs as described in the followingsections.IP API ChangesFollowing is the enhancement for ipschema introduced in 8.1: The pSearchObj parameter is now available even for the DAMOBJ TYPE SCHEMAschema type. The IP can use this information or pass the pSearchObj to the OpenAccessSDK SQL engine when calling the dam add damobj xxxxx functions. It is NULL if nosearch criteria is specified.DAM API Changes Enhanced the dam getInfo API to retrieve the client version with theDAM INFO CLIENT PRODUCT VERSION info type. Enhanced the dam getInfo API to retrieve the cipher suite and cryptoprotocol versionbeing used to connect to the OpenAccess SDK Server with the following info types: DAM INFO SESSION CIPHER SUITE DAM INFO SESSION CRYPTO PROTOCOL VERSION.NET IP for OpenAccess SDK SQL EngineRefer to the OpenAccess SDK SQL Engine Programmer’s Reference for .NET for details on settingup the environment to code your IP. Once you have set up the environment, copy your IP code to thenew folder and make changes to the IP APIs and DAM/DAMEX APIs as described in the followingsectionsIP API ChangesFollowing is the enhancement for ipschema introduced in 8.1: The pSearchObj parameter is now available even for the DAMOBJ TYPE SCHEMAschema type. The IP can use this information or pass the pSearchObj to the OpenAccessSDK SQL engine when calling the dam add damobj xxxxx functions. It is NULL if nosearch criteria is specified.DAM API Changes Enhanced the dam getInfo API to retrieve the client version with theDAM INFO CLIENT PRODUCT VERSION info type. Enhanced the dam getInfo API to retrieve the cipher suite and cryptoprotocol versionbeing used to connect to the OpenAccess SDK Server with the following info types: DAM INFO SESSION CIPHER SUITE DAM INFO SESSION CRYPTO PROTOCOL VERSIONProgress Software Corporation September 20167

C SQL IPRefer to the OpenAccess SDK Third-Party SQL Engine Programmer’s Guide for details on settingup the environment to code your IP. Once you have set up the environment, copy your IP code to thenew folder and make changes to the IP APIs as described below.IP API Changes Enhanced the OASQLIP set connect info API to retrieve the client type and clientversion with the following info types: OADS CONN INFO CLIENT TYPE OADS CONN INFO CLIENT PROD VERSION Enhanced the OASQLIP set connect info API to retrieve the cipher suite andcryptoprotocol version being used to connect to the OpenAccess SDK Server with thefollowing info types: OADS CONN INFO SESSION CIPHER SUITE OADS CONN INFO SESSION CRYPTO PROTOCOL VERSIONPlease update this API in the IPJava SQL IPRefer to the OpenAccess SDK Third-Party SQL Engine Programmer’s Guide for details on settingup the environment to code your IP. Once you have set up the environment, copy your IP code to thenew folder and make changes to the IP API as described below.IP API Changes Enhanced the sqlipSetInfo API to retrieve the client type and client version with thefollowing info types: OADS CONN INFO CLIENT TYPE OADS CONN INFO CLIENT PROD VERSION Enhanced the sqlipSetInfo API to retrieve the cipher suite and cryptoprotocol versionbeing used to connect to the OpenAccess SDK Server with the following info types: OADS CONN INFO SESSION CIPHER SUITE OADS CONN INFO SESSION CRYPTO PROTOCOL VERSIONPlease update this API in the IPBranding and DistributionNo changes.Progress Software Corporation September 20168