[Qt-interest] [QtSql] ODBC driver _always_ returns 256 lines with DB2 for i5

[Emmanuel Bourgerie]

Hi folks,

I'm developing a little SQL EDI based on Qt, which works pretty fine
except when I'm working with ODBC. Usually I work with natives
drivers, but I need to use ODBC with IBM DB2 for i5.

The problem is, by making queries or browsing tables I always have 256
results. If a query returns 3 lines, they will be fetched well but the
252 remaining will be "blank". Now imagine a 1 or 2Ko line (some
CHAR(150) are enough) and I have to fetch more than 250k, by the way
with an incredibly low bitrate.

I thought first that IBM was responsible, because that's not the first
time we experience troubles with their drivers, but I tried on AnySQL
Maestro (http://www.sqlmaestro.com/products/anysql/maestro/). Even if
I've some latencies with this one, the result count seems good.

Anyway, PostgreSQL works fine over ODBC, so I do not really know if
the problem comes from DB2 or Qt...