============================================================================ IBM i Access Client Solutions - Windows Application Package 5733-XJ1 Version: 1.1.0.27 ESS ID: LCD8-2011-17 (c) Copyright IBM Corporation 2022. All rights reserved. ============================================================================= NOTICE: ------- Application of this Service Pack may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This Service Pack may be a prerequisite for future Service Packs. By applying this Service Pack you authorize and agree to the foregoing. This Service Pack is subject to the terms of the license agreement which accompanied, or was contained in, the Program for which you are obtaining the Service Pack. You are not authorized to install or use the Service Pack except as part of a Program for which you have a valid Proof of Entitlement. SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT, REGARDING THE SERVICE PACK. The applicable license agreement may have been provided to you in printed form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR) CL command. --------------------------------- Version: 1.1.0.27 Build Date = November 2022 --------------------------------- When using TLS (SSL), SSLv3, TLS 1.0, and TLS 1.1 are now disabled. TLS 1.3 is also now enabled, but only when FIPS mode is disabled since the current GSKit FIPS module does not yet support TLS 1.3. APAR SE78010 OSP-INCORROUT ODBC CONFIGURATION WINDOW DOES NOT OPEN APAR SE78013 OSP ACS WINAP OLEDB OLDER EXCEL MIGHT CRASH APAR SE78044 OSP-INCORROUT ODBC INCORRECT COLUMN LABEL INFORMATION APAR SE78102 OSP-UNPRED WINAP 1.1.0.26 - MICROSOFT CURSOR ENGINE: DATA PROVIDER OR OTHER SERVICE RETURNED AN E_FAIL STATUS APAR SE78694 OSP-UNPRED PASE - ODBC - DBCS - SQL0104 FOR SELECT SQL STATEMENT --------------------------------- Version: 1.1.0.26 Build date = May 2022 --------------------------------- APAR SE75789 OSP .NET DRIVER WILL NOT ALWAYS CATCH THEN EXCEPTION IN A TRY CATCH CLAUSE APAR SE75879 OSP-INCORROUT SYSTEM KEYWORD NOT RECOGNIZED IN DSN-LESS ODBC CONNECTION APAR SE76176 OSP-INCORROUT ODBC - CWBNL0107 FOR SPECIFIC CHARACTERS WITH TARGET CODE PAGE 1202 APAR SE76907 OSP-INCORROUT ACTIVEX DATA QUEUE TEXT BOX CONTROL CHARACTER CONVERSION INCORRECT. APAR SE77094 OSP-THREADS-WAIT PASE ODBC DRIVER DELAY SQLGETINFO APAR SE75812 OSP-UNPRED MEMORY LEAK IN ODBC DRIVER --------------------------------- Version: 1.1.0.25 Build date = May 2021 --------------------------------- APAR SE75377 OSP-INCORROUT CWBOBJ_OPENLIST API GENERATES AN EXCEPTION APAR SE75463 OSP ACS WINDOWS AP ODBC {FN CURRENT_DATE()} MIGHT CRASH WITH WHERE CLAUSE APAR SE75755 OSP-UNPRED CUSTOMER'S APPLICATION HANGS WHEN USER PROFILE PASSWORD EXPIRATION INTERVAL IS MET --------------------------------- Version: 1.1.0.24 Build date = August 2020 --------------------------------- APAR SE73817 OSP-INCORROUT ONLY 200 ROWS OF DATA ARE FETCHED BY ODBC DRIVER --------------------------------- Version: 1.1.0.23 Build date = February 2020 --------------------------------- IBM Key Management has been removed from this update as it was part of the IBM JRE 1.6 which has been removed. A replacement will not be provided. For importing certificates to Windows, IBM i Access Client Solutions (ACS) provides two options: 1. The cwbcossl command is still available as part of the Windows Application Package. 2. In the ACS base package, from the main GUI, select Tools->Key Management. From there you can select a certificate and the option to Push to Windows... Installed versions of Java provide a command line tool (keytool) for other certificate management functions. APAR SE72583: CA400EXP-OLEDB-INCORROUT BLOCK SIZE PROPERTY IGNORED APAR SE72916: OSP INSTALLING ACS WINDOWS APPLICATION PACKAGE WITH LANGUAGE BRAZILAN PORTUGESE MIGHT FAIL RFE 137587: Remove JRE 1.6 --------------------------------- Version: 1.1.0.22 Build date = May 2019 --------------------------------- APAR SE70688: CA400EXP-SERVICE-INCORROUT CWBSVGET LOG MISSING REGISTRY DATA APAR SE71039: CA400EXP-APIS-NLS-INCORROUT CCSID 937 USING 28709 FOR SBCS RATHER THAN 37 APAR SE71097: CA400EXP-ODBC-MSGSQL0181 LINUX ODBC DRIVER CONVERTING STRING TO TIME INCORRECTLY APAR SE71133: CA400EXP-ODBC-THREADS-PERFM IBM I ACCESS CLIENT SOLUTIONS LINUX ODBC DRIVER MEMORY USAGE GROWTH --------------------------------- Version: 1.1.0.21 Build date = November 2018 --------------------------------- APAR SE69991: CA400EXP-ODBC-MSGSQL0904 RESOURCE LIMIT TYPE 7 EXCEEDED WITH REASON CODE 168 --------------------------------- Version: 1.1.0.20 Build date = May 2018 --------------------------------- APAR SE68537: CA400EXP-OLEDB-F/QSQCLNUP-T/QSQCLNUP-RC13-MSGSQL0904 BLOCK SIZE TOO SMALL APAR SE68605: CA400EXP-IDB2DATA-THREADS-PERFM SLOW THREADS LOOKING FOR OPEN CONNECTIONS WHEN A CONNECTION IS BEING VERIFIED OR CLOSED APAR SE68390: CA400EXP-COMM-INCORROUT MISSING HELP TEXT APAR SE68793: OSP-UNPRED ACS WINDOWS ODBC DRIVER WILL FAIL WITH ACCESS VIOLATION WHEN USING *USRLIBL AT 64 BIT DATA SOURCE APAR SE68610: CA400EXP-ODBC-INCORROUT TIMESTAMP PRECISION APAR SE68844: OSP-INCORROUT ODBC HEAP ADDRESS ERRORS OR DELPHI DEBUGGER STOPS AT A "NON-USER BREAKPOINT" APAR SE68848: OSP-INCORROUT ODBC EXCEL MSQUERY DOES NOT WORK TO CHANGE THE QUERY --------------------------------- Version: 1.1.0.18 Build date = October 2017 --------------------------------- APAR SE68044: CA400EXP-SSL-INCORROUT CWBCOSSL FAILS TO IMPORT JAVA CA APAR SE67343: CA400EXP-IDB2DATA-INCORROUT .NET MANAGED PROVIDER MISSING PARAMETER EXCEPTION FOR QUESTION MARK IN AN SQL COMMENT APAR SE67749: CA400EXP-IDB2DATA-INCORROUT IDB2DATAADAPTER INCORRECT WIDTH FOR GRAPHIC, VARGRAPHIC AND DBCLOB FIELDS --------------------------------- Version: 1.1.0.16 Build date = May 2017 --------------------------------- APAR SE66926: CA400EXP-IKEYMAN DOES NOT HONOR THE PROPERTIES LANGUAGE TAB SETTING APAR SE66636: CA400ECP-ODBC-INCORROUT SQL_NO_TOTAL PROBLEM WITH ODBC APAR SE66663: CA400EXP-ODBC-INCORROUT ALL COLUMN VALUES BOUND AS NULL WHEN USING BLOCK INSERT APAR SE66664: CA400EXP-IDB2DATA-MSGSQL0666 .NET MANAGED PROVIDER COMMANDTIMEOUT NOT CHANGED APAR SE64933: CA400EXP-OLEDB-MSGSQL0104 LINKED SERVER OPENQUERY INSERT FAILING WHEN USING SYSTEM NAMING CONVENTION AND NO LIBRARY NAME APAR SE67000: CA400EXP AFP VIEWER WILL RECEIVE A 1393: MESSAGE WHEN LOOKING AT SPOOLFILE WITH BARCODE --------------------------------- Version: 1.1.0.15 Build date = October 2016 --------------------------------- APAR SE65806: CA400EXP-INCORROUT CONVERSION TABLE DOWNLOAD SYSTEM VARIES APAR SE65922: CA400EXP-ODBC-UNPRED Data is messed up if no shift-in APAR SE65773: OSP SQLDRIVERCONNECT NOT REPORTING ERRORS CORRECTLY IN LAST TWO SERVICE PACKS --------------------------------- Version: 1.1.0.14 Build date = May 2016 --------------------------------- APAR SE64636: CA400EXP-INSTALL-UNPRED MISSING MFCLOC MODULES APAR SE63488: CA400EXP-DTRANSFER-INCORROUT CWBTF0005 FOR THE COLUMN HEADING APAR SE64833: CA400EXP-DTRANSFER-INCORROUT DT FAILURES NOT REPORTED APAR SE63287: CA400EXP-ODBC-INCORROUT CWB0111 UTF-8 PARAMETER DATA APAR SE63307: CA400EXP-ODBC-INCORROUT FILE DSN SIGNON TYPE APAR SE63628: CA400EXP-ODBC-UNPRED FIELD DATA IS TRUNCATED APAR SE63700: CA400EXP-ODBC-INCORROUT LINUX ODBC NOT RETURNING COLUMN NAMES CORRECTLY TO CALLER APAR SE63801: CA400EXP-ODBC-INCORROUT ERROR INVALID PARAMETER NUMBER RETURNED AFTER CALLING SQLFREESTMT(SQL_RESET_PARAMS) APAR SE64596: CA400EXP-ODBC-UNPRED UNEXPECTED 0F0E INSERTED BETWEEN KANJI AND DBCS BLANKS APAR SE64600: CA400EXP-ODBC-INCORROUT DATES AND TIMES NOT CONVERTED TO WIDE CHARACTERS APAR SE64252: CA400EXP-IDB2DATA-INCORROUT .NET CONNECTION CLOSED BY GARBAGE COLLECTOR IS CAUSING EXCEPTION APAR SE63893: CA400EXP-AFPVIEWER-INCORROUT DEFAULT BARCODE HEIGHT WAS GETTING CHANGED BETWEEN EACH BARCODE APAR SE64884: CA400EXP-DTRANSFER-INCORROUT RTOPCB BIFF8 LOST DECIMALS --------------------------------- Version: 1.1.0.13 Build date = October 2015 --------------------------------- APAR SE62758: CA400EXP-ODBC-UNPRED EVENT-ID 1000 LOGGED IN WINDOWS EVENT LOG FOR CWBODBC.DLL WHEN AN APPLICATION CONNECTS TO IBM I 7.2 SYSTEM APAR SE62994: CA400EXP-ODBC-UNPRED ACS APPLICATION PACKAGE FOR LINUX ODBC DRIVER "CCSID" CONNECTION STRING KEYWORD NOT WORKING AS DESIGNED --------------------------------- Version: 1.1.0.12 Build date = May 2015 --------------------------------- APAR SE61342: CA400EXP-ODBC-F/QSQRUN2-T/QSQRUN2-RC501-MSGMSGSQL0501 INSTALLATION OF SI53809 CAUSES SQL0501 IN ODBC APPLICATION APAR SE61465: CA400EXP-ODBC-INCORROUT ODBC FAILING IN FOXPRO APAR SE61519: CA400EXP-IDB2DATA-THREADS-INCORROUT IMPROVE ERROR FOR CONVERSION FAILURES --------------------------------- Version: 1.1.0.11 Build date = February 2015 --------------------------------- APAR SE61082: CA400EXP-INCORROUT YEN SYMBOL CONVERSION ERROR WITH SI53809 APAR SE60616: CA400EXP-ODBC-INCORROUT ODBC CONNECTION FAILS WITH NO PRIMARY KEYS APAR SE61173: CA400EXP-ODBC-INCORROUT RESTRICTED DATA TYPE ATTRIBUTE VIOLATION CALLING SQLGETDATA WITH 0 BYTE BUFFER APAR SE61221: CA400EXP-ODBC-INCORROUT ODBC INSERT DATA CORRUPTED WITH SERVICE PACK SI53809 --------------------------------- Version: 1.1.0.11 Build date = October 2014 --------------------------------- APAR SE59290: CA400EXP-ODBC-MSGSQL0952 PROGRAM CALL INTERMITENT TIMEOUT APAR SE59344: CA400EXP-ODBC-UNPRED APPLICATION FAULTS AND CLOSES ON A QUERY THAT DOES A CALCULATION APAR SE59386: CA400EXP-ODBC-INCORROUT UNEXPECTED CHARACTERS IN OUTPUT DOING A SIMPLE SELECT STATEMENT APAR SE59960: CA400EXP-ODBC-UNPRED CWBODBCREG LIMITATIONS APAR SE60184: CA400EXP-ODBC-MSGSQL0180 ODBC SELECT & INSERT STATEMENTS FAIL WITH MSGSQL0180 IN IBM I ACCESS FOR WINDOWS SERVICE PACK SI53584 APAR SE60361: CA400EXP-ODBC-PERFM BLOCKING WITH LOB LOCATORS APAR SE59245: CA400EXP-OLEDB-INCORROUT DATA TRUNCATED ON INSERT APAR SE59367: CA400EXP-OLEDB-INCORROUT STATEMENT NOT FOUND APAR SE60314: CA400EXP-IDB2DATA-INCORROUT .NET PROVIDER TIMESTAMP PROBLEMS --------------------------------- Version: 1.1.0.10 Build date = May 2014 --------------------------------- APAR SE57158: CA400EXP-CONNECTIONS-INCORROUT CWBSY0002 ON WINDOWS 8.1 APAR SE57535: CA400EXP-SECURITY-UNPRED NO PASSWORD CHANGE FAILURE DETAIL APAR SE56950: CA400EXP-DTRANSFER-UNPRED CWBTF0105 ON XLS UPLOAD TO IBM I APAR SE57759: CA400EXP-ODBC-INCORROUT INCORRECT HANDLING OF ROW-WISE PARAMETER BINDING APAR SE57797: CA400EXP-ODBC-INCORROUT SQLGETTYPEINFO (ALL DATATYPES) THROWS INCORRECT OUTPUT FOR CREATE_PARAMS APAR SE57867: CA400EXP-ODBC-INCORROUT SQLCOLUMNS() REPORTS DATA_TYPE & SQL_DATA_TYPE AS -1 (LONGVARCHAR), NOT -370 (XML) APAR SE58113: CA400EXP-ODBC-UNPRED MSGCWBNL0107 WHEN RECORD DOES HAVE X'E0' (SHIFT OUT) BUT NO X'0F' (SHIFT IN) APAR SE57049: CA400EXP-IDB2DATA-MSGSQL0519 CONNECTION WITH IBM I ACCESS FOR WINDOWS .NET DRIVER RESULTS IN SQL0519 WHEN SQL COMMENTS ADDED APAR SE57162: CA400EXP-IDB2DATA-INCORROUT FORMAT EXCEPTION DURING CONNECTION APAR SE57569: CA400EXP-AFPVIEWER-UNPRED AFP WORKBENCH VIEWER (FTDWINVW.EXE) CANNOT START BECAUSE ICUUC44.DLL MISSING --------------------------------- Version: 1.1.0.9 Build date = October 2013 --------------------------------- APAR SE56004: CA400EXP-DTRANSFER-UNPRED MSGCWBTF0005 WITH YEN SIGN IN FIELD NAME DURING UPLOAD TO IBM I APAR SE56678: CA400EXP-UNPRED HEAP FREELIST CORRUPTION BY CWBCORE.DLL APAR SE56576: CA400EXP-IDB2DATA-INCORROUT CANCEL FUNCTION WITH .NET PROVIDER SENDS INVALID PASSWORD APAR SE56657: CA400EXP-DTRANSFER-INCORROUT CWBDB0014 - INTERNAL SOFTWARE ERROR (SYSTEM %1) APAR SE54136: CA400EXP-AFPVIEWER-INCORROUT QUALITY OF THE VIEWED PAGE IS NOT AS GOOD AS BEFORE APAR SE54364: CA400EXP-AFPVIEWER PRINT ALL PAGES WITH AFP WORKBENCH VIEWER GENERATES BLANK OUTPUT APAR SE54590: CA400EXP-AFPVIEWER AFP VIEWER DOES NOT VIEW TWO OVERLAYS FROM DIFFERENT LIBRARIES ------------------------------------------------------------------- [END OF DOCUMENT]