[Gambas-user] ODBC - unable to fetch row

[Christof Thalhofer]

Am 23.01.21 um 11:13 schrieb KKing:

> @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.

Ok then i would recommend at first creating a migration path to
Postgresql (which i also recommend over Mysql/Mariadb) or Sqlite.
Because Gambas works best with these databases. If you want to use
Gambas you will further or later have to do the migration work. But if
you want to marry Gambas with Access databases you will struggle and
have unnecessary work.

If you have migration scripts which work then you can switch over to
Gambas/PG at any time you have the Gambas application done. You may even
be able to work on PG dbs with Access and Gambas in parallel.

For Postgresql you may want to have a look at this:

https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access

I had the data of my firm in MS Access and mdb databases about 20 years
ago, then first migrated the data to PG and later replaced the Access
VBA application with Gambas. So I know, what i am talking about.

Alles Gute

Christof Thalhofer

-- 
Dies ist keine Signatur

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20210123/d97aed8c/attachment.sig>