[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