Hi Jozef,

It is really difficult to to give an answer without having the code for your form, but I try to guess.

Jim's example uses dedicated ODBC statement handle. That is why it requires shared connection, SQLConnect( this.Parent.datasource ) obtains new statement handle for existing connection and it should fail if this.Parent.datasource doesn't represent shared connection.
Looks like your form shares the same statement handle between all CursorAdapters, it should work fine with FetchSize=-1 regardless whether connection is shared or not.

Thanks,
Aleksey.