[Gambas-user] ODBC - unable to fetch row

[KKing]

Hi Charlie,

the subject "ODBC - unable to fetch row" is specific to trying to use 
unixODBC+mdbtools which @zxMarce has confirmed.

the quoted text from @PICCORO is relating to a separate test I did with 
sqlite (not MS SQL) that got past the .exec statement (that mdbtools 
fails on) but when trying to check the number of records or to loop 
through result via gb.odbc it reports there is only 1 record where as 
the unixodbc isql utility (that effectively should be what the gb.odbc 
call should be doing) is providing the expected 1,000 records.

So I'm not entirely sure what you are saying ... is it that with MS SQL 
and a non unixodbc? driver it is works for you?
K.