[Gambas-user] ODBC - unable to fetch row

KKing kicking177 at gmail.com
Sat Jan 23 11:13:58 CET 2021


fyi I did replicate both issues on 3.15.2 (from repo) on Debian 11 
(Bullseye).

@Benoit
> as I don't know ODBC and didn't write the driver
no problem, I only know how to (attempt to) use ODBC :-)

@PICCORO
> odbc cannot count on resultset
Thank you for confirming and the link.

@Christof
> Why do you want to interact with an old MsAccess mdb?
> This is a very ugly piece of a database.
Because I have a potential client who has a large amount of their 
information in multiple MDB's. We are looking at various solutions that 
may slowly migrate them off those and onto either sqlite if standalone 
or MySQL/MariaDB/Postrgres if serious multiuser need. Depending on 
timescales and approach may require read only access to some of the 
MDB's for a period of time, there is also a desire to do some back to 
back testing and or parallel running where we can confirm any 
replacement system does generate and store the same information as was 
generated in the MDB.

@zxMarce.
> I did download at home Northwind.Mdb, MS's test Access database, and 
> -sure enough- got the same issue
>
> I will try
Thank you, I started looking at code, but.

K.


More information about the User mailing list