DEFECTS.HTML FOR IBM Informix Client SDK Date: October 2007 Version: 3.00.xC3DE I. Customer-reported known problems in 3.00.xC3 =============================================== APAR: Component: Description IC53072 .NET-GENERIC DOTNET FAILS WITH CONNECTION POOL HAS REACHED THE MAXIMUM NUMBER OF CONNECTIONS IC53397 .NET-GENERIC BLOB DATA IS STORED IN THE DEFAULT SBSPACE REGARDLESS OF THE STORAGE INFORMATION IN THE TABLE. IC53919 .NET-GENERIC ISOLATION LEVEL SET FOR COM COMPONENTS DOES NOT GET PROPAGATED TO .NET PROVIDER IC53553 .NET-PROV-2.0 SUPPORT FOR PROMOTABLE SINGLE PHASE ENLISTMENT WITH SYSTEM TRANSACTIONS IC51670 ESQL/COB-GEN KEEP CURSORS WITHOUT WITH HOLD CLAUSE OPEN WHEN AUTOCOMMIT IS USED IC52998 IDS-3RDPAR-WIN ODBC: ODBCEXCEPTION THROWN WHEN CONNECTIONS ARE INITIATED TOO QUICKLY. IC53410 ODBC-GENERIC MSDTC: XA_COMMIT IS DELAYED WHEN A SECOND STATEMENT IS EXECUTED AFTER FIRST STATEMENT GETS XA_PREPARE IC52722 ODBC-GLS ODBC ERROR -1226 WITH DECIMAL TYPE AND DB_LOCALE OTHER THAN EN_US IC53022 ODBC-MTS ODBC ERROR [25000] FOR NON-XA TRANSACTION WHEN IT FOLLOWS A XA TRANSACTION TOO FAST IC53554 ODBC-MTS ODBC: TRANSACTIONSCOPE.DISPOSE DOES NOT ROLLBACK UNCOMMITTED TRANSACTIONS IC53023 OLEDB-GENERIC OLEDB PROVIDER SHOWS BAD PERFORMANCE COMPARED TO ODBC IC53444 OPTICAL-GEN SQLBREAK() IS NOT CALLED WHEN OPTICAL DISK FAILS OR IS TAKEN OFFLINE. IC53807 SDK-GENERIC SECURITY: PASSWORD SHOULD BE ENCRYPTED IN MEMORY IC53059 SDK-INSTALL MISSING LIBRARIES LIBTOS.SL & LIBTSQL.SQL FROM I-CONNECT 2.90 II. Customer-reported defects fixed in 3.00.xC3 ============================================== APAR: Component: Description IC53947 .NET-PROV-1.1 INVALID ARGUMENT EXCEPTION WHEN TURKISH LOCALE IS USED. IC53028 .NET-PROV-2.0 .NET: EXCEPTION THROWN WHEN IFXCONNECTIONS ARE INITIATED TOO QUICKLY. IC53337 .NET-PROV-2.0 GLOBAL TRANSACTIONS SHARING A POOLED CONNECTION MAY LEAD TO DEADLOCK/TIMEOUT IC53555 ESQL/C-ASF CLIENT SHM CONNECTIONS WHEN -THREAD FLAG USED AND NOT USING DCE THREADS, NOT RANDOMLY DISTRIBUTED TO SHM POLL THREADS IC52731 ESQL/C-GENERIC INFXCEXP.C FILE NEEDS TO BE UPDATED WITH THE FUNCTION NAMES FOR VS2005 IC53926 ESQL/C-GENLIB CONFLICTING DEFINITIONS OF LOC_T IN LOCATOR.H (ESQL) AND LOCALEDEF31.H (AIX) STOP COMPILATION IC53965 ESQL/C-SQLI GETENV SHOULD NOT BE CALLED FROM A DLLMAIN FUNCTION IC52929 ODBC-GENERIC A TIMEOUT OF MSDTC (WITH ROLLBACK) WILL NOT DETECTED CORRECTLY BY THE ODBC-DRIVER WHEN USING MSDTC AND CONNECTION POOLING. IC52970 ODBC-GENERIC MSDTC TRANSACTION WILL HANG IF WAITING FOR A LOCK AND THE LOCK WAIT EXCEEDS IFXCOMMAND.COMMANDTIMEOUT IC53169 ODBC-GENERIC ERROR -608 WHEN INSERTING BYTE FIELDS <= 8000 BYTES RETRIEVED BY ODBCDATAREADER IC53258 ODBC-GENERIC ODBC: QUERY WITH A LARGE WHERE CLAUSE MAY CAUSE ACCESSVIOLATIONEXCEPTION IC53289 ODBC-GENERIC ODBC: SUCCESSIVELY PARSING STATEMENTS OF DIFFERENT LENGTH MAY CAUSE ACCESSVIOLATIONEXCEPTION ERRORS IC52898 ODBC-MTS MSDTC TRANSACTIONS MAY STUCK IN XA PREPARE IC53180 ODBC-MTS NTDLL CRASHES, -11060 GENERAL ERRORS AND COMMUNCIATION ERROR FIXES FOR MSDTC IC52715 OLEDB-GENERIC ERROR: THE OLE DB PROVIDER IFXOLEDBC FOR LINKED SERVERSUPPLIED INCONSISTENT METADATA FOR A COLUMN. III. Customer-reported defects fixed in 3.00.xC2 ============================================== APAR: Component: Description IC52482 ESQL/C-SQLI WHEN A CURSOR THAT HAS BEEN USED WITH DEFERRED_PREPARE ENABLED AND OPTOFC=1, IT RETURNS AN ERROR 410 WHEN DEFERRED_PREPARE DISABLED IS USED IC51372 ODBC-GEN SQLPREPAREW FAILS WITH ERROR -21000 INVALID BYTE IN CODESET CONVERSION INPUT WHEN USING UTF-16 AND UNICODE IC51943 ODBC-GEN UPDATING A TEXT TYPE IN A MULTI-COLUMN FORMAT IN ODBC RETURNS -201 OR -608 IC52725 ODBC-GEN .NET APPLICATION ALLOCATES LARGE AMOUNT OF MEMORY WHEN CONNECTED VIA ODBC IC52481 ODBC-GEN J# RETURNS UNKNOWN COLUMN NAME WHEN USING THE INFORMIX ODBC DRIVER IC52538 ODBC-GEN DATA RETURNED AS SQL_C_WCHAR DOES NOT HANDLE SPACES CORRECTLY IC52591 OLEDB-GEN RETRIEVING A MONEY COLUMN USING OLEDB FROM A .NET APPLICATION RETURNS INCORRECT VALUES IF THE DECIMAL SEPARATOR IS NOT THE DEFAU IV. Customer-reported defects fixed in 3.00.TC1 ================================================ ICONNECT-INSTALL 174968 DOT NET PROVIDER REQUIRE THE MS FRAMEWORK SDK ESQL/C APAR IC51622 AN ESQLC SEGMENTATION FAULT OCCURS WHEN EXEC SQL DISCONNECT CONTAINS AN UNDECLARED HOST VARIABLE APAR IC50012 THE CONTENT OF A COLUMN WITH THE TYPE LVARCHAR NOT NULL CANNOT BE DISPLAYED APAR IC49654 QUERY RETURNS 0 ROWS WHEN HOSTVAR FOR FILTER IS AN EMPTY STRING APAR IC51886 QUERY RETURNS 0 ROWS WHEN HOSTVAR FOR FILTER IS AN EMPTY STRING APAR IC50423 ERROR 1831 OCCURS WHEN USING AN LVARCHAR WITH A FETCH ARRAY APAR IC51226 TABLE LEVEL RESTORE ON WINDOWS RETURNS A CRITICAL ERROR: GLS INITIALIZATION FAILED APAR IC50012 THE CONTENT OF COLUMN WITH TYPE "LVARCHAR NOT NULL" CANNOT BE DISPLAYED WITH CSDK 2.90.UC4 APAR IC50423 ERROR 1831 WHEN USING LVARCHAR WITH A FETCH ARRAY APAR IC50102 A 4GL DATETIME VARIABLE VALUE DOESN'T CHANGE AFTER CHANGING TZ. .NET-PROVIDER APAR IC50331 IBM.DATA.INFORMIX.IFXEXCEPTION: ERROR - NO ERROR INFORMATION AVAILABLE APAR IC51399 ERROR 'INVALIDCASTEXCEPTION: OBJECT MUST IMPLEMENT ICONVERTIBLE' WHEN PASSING A BLOB TO A STORED PROCEDURE ERROR 'INVALIDCASTEXCEPTION: OBJECT MUST IMPLEMENT ICONVERTIBLE' WHEN PASSING BLOB TO STORED PROCEDURE. APAR IC49963 ERROR INVALIDCASTEXCEPTION: OBJECT MUST IMPLEMENT ICONVERTIBLE WHEN PASSING BLOB TO STORED PROCEDURE. ERROR 'INVALIDCASTEXCEPTION: OBJECT MUST IMPLEMENT ICONVERTIBLE' WHEN PASSING B LOB TO STORED PROCEDURE. ODBC 172209 ICE : CREATING 2 DIFFERENT DATASOURCES WITH THE SAME INFORMIXSERVER VALUE, MAKES THE HOSTNAME IDENTICAL FOR BOTH DATASOURCES. APAR IC50562 ODBC CONNECTION IN CONJUNCTION WITH UNIX ODBC MANAGER ON 64BIT LINUX CSDK RETURNS AN ERROR MESSAGE APAR IC50772 UNKNOWN SQL TYPE - -30964. AT IBM.DATA.INFORMIX.TYPEMAP.FROMSQLTYPE(SQL_TYPE SQLTYPE) APAR IC50846 WITH ODBC THE ERROR -11003 APPEARS WHEN MORE THAN 56 BYTES WILL BE STORED INTO A BYTE FIELD APAR IC51828 UPDATING A TEXT COLUMN TO AN EMPTY STRING UPDATES ALL ROWS OMITTING THE WHERE CLAUSE LIBDMI APAR IC50619 MEMORY ERRORS OCCUR IN LIBDMI WHEN USED WITH THE TIMESERIES TYPE OLEDB APAR IC49745 ERROR TRANSACTION MANAGER IS UNAVAILABLE OR XACT_E_TMNOTAVAILABLE ON WINDOWS APAR IC50979 USING OLE/DB TO RUN A QUERY WHICH HAS 38 SELECT STATEMENTS RESULTS IN THE ERROR B_E_ERRORSINCOMMAND APAR IC50991 THE OLE DB PROVIDER IFXOLEDBC SUPPLIED INCONSISTENT METADATA FOR A COLUMN. METADATA INFORMATION WAS CHANGED AT EXECUTION TIME. APAR IC51563 THE COLEDBP.SQL PROVIDED WITH CSDK 2.90.TC6X2 CAUSES A SYNTAX ERROR AGAINST IDS 7.31 APAR IC51789 IFXOLEDBC OLEDB PROVIDER FAILS TO INSERT USING OPENQUERY VIA AN SQLSERVER LINKED SERVER, ASSERT FAILING IN ROWSET.CPP LINE 1331 APAR IC51738 .NET/OLE DB PROVIDER IS NOT ABLE TO DISPLAY DATA TYPE DECIMAL(p) (C) Copyright IBM Corp. 1994, 2007