IBM Informix Messages and Corrections

                         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 SERVER  SUPPLIED 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