Informix on NT ODBC Driver Bug
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET
Check your application!
I have found (and reported to Informix) a problem with the Informix 2.80
ODBC driver which comes with Dynamic
Server 7.3 for NT. This can only be resolved (?) by using the driver
supplied by INTERSOLV which also comes on the disk.
(I can't say that there aren't other problems with the Intersolv one 'cos I
only just switched).
The problem is this:
I have a table with two DATETIME columns (I think the precision is
un-important). Then I run the following:
SELECT firstdatecol, seconddatecol FROM table WHERE whatever;
If firstdatecol contains NULL then you don't get a value for seconddatecol
FOR THAT ROW, even when selecting from seconddatecol alone gives values
(infact it's a NOT NULL column in my table). I don't know if the
null-ability is important, but the first can be NULL and the second can't.
Anyone know of any problems with the Intersolv ODBC driver I've had to
switch to?
Pete Bloxam
(Pete is a Database Administrator in a large UK software house, but
opinions are those of Pete and not of his employer).