[Firebird-odbc-devel] How can I retrieve more than 100 rows from a single query?

[Jean-Louis D. <jea...@ya...>]

 Using DAO in VB6.
I connect to Firebird 2.0 through Firebird/Interbase(r) driver
(IscDbc.dll 2.0.0.131)
My connection string is "ODBC;DRIVER=Firebird/InterBase(r)
driver;UID=SYSDBA;PWD=masterkey;DBNAME=C:\Jumpware.fdb"
Everything works great but I can only retrieve the first 100 records
with a simple SELECT query.
When using FlameRobin, I can retrieve the whole table with the same query.
What am I missing?

Jean-Louis