Post by hoosierdaddytim on Jun 16, 2020 15:01:25 GMT -5
I just received an email from Carl at LB because I had asked about DB use and LB. He explained I should join the forum, so here I am. He also said the next version ( I assume ) or version 5.0 will have DB connectivity built in?
So, I have some questions. Can you use ODBC to connect to db's now such as SQL server, Oracle, SQL lite, etc?
I have been trying to find a FE tool such as LB that would replace what I used to use VB for, and would allow me to design on premises software for small business that will be using small to medium size DB's such as SQL server, etc.. Sql express, MS Access, Filemaker, etc.. Is there an ADO type thing in LB that can be used?
Anyone know how much easier it will be to use the next version of LB for db work?
Post by Brandon Parker on Jul 12, 2020 19:32:30 GMT -5
You most definitely can, but it is more difficult with the current version. That being said, if you take the code linked below and reorganize it you might find that it is not too difficult after all ... just tedious.
It is Dennis McKinney's version for Access databases, here adapted by Onur Alver for MySQL.
The ODBC connector is too old, I had to replace it. The program works on Windows 10 with the 32 bit 5.3 ANSI Driver that can be downloaded from the official MySQL website.
Surprisingly, LB 4.5.1 refuses obstinately to read the latest version 8.0 of the ODBC connector. It shows runtime error 16r7E 'specified module could not be found'. After multiple updates of the VC++ redistributable runtime library, the error message remains the same.
Not a big deal, because the program runs under version 5.3, but it is still a strange behaviour.....