New person here. Questions about DB backends, LB frontends..

[hoosierdaddytim]

Hi Everyone.

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?

Any examples?

Anyone know how much easier it will be to use the next version of LB for db work?

Thanks in advance
Tim 

[Brandon Parker]

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.

www.libertybasicuniversity.com/lbnews/nl102/8.htm


{:0)

Brandon Parker

[pierre]

A working  example can be found here:

MySQL/MariaDB

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

Any suggestion would be very much appreciated.

pierre