HMGforum.com

Ismach wrote: ↑Fri Mar 26, 2021 8:07 pm A tener en cuenta amigos, como Mariadb se desligo de algunas partes NO GPL que solia tener Mysql en sus inicios a partir de Mariadb version 10 dejo de incorporar algunos gestores internos de almacenamiento e indexacion y tambien dejo de incorprar libmysql.Dll y la reemplazo por LibMariadb.dll pero internamente tambien cambio de manera que no tenemos la libmariadb.a ni libmariadb.lib para HMG si usamos Mariadb 10, yo ya lo habia comentado antes.
Saludos

Teniendo LibMariadb.dll se puede exportar y construir LibMariadb.a

Hola...
Con MariaDB viene HeidiSQL (si lo queremos instalar) y en él están esas librerías. También en las carpetas de MariaDB hay muchas más.
Con sólo poner libmysql.dll (es la que pide la función de Harbour)
en la carpeta junto a los archivos del programa me funciona perfecto
tanto con bases MySQL como MariaDB (hasta la v. 5.5.68 es 100% compatible)

Si necesitan los conectores para C, C++ y otros lenguajes:
https://downloads.mariadb.org/connector-c/+releases/

Claudio,

HeidiSQL + Maria + HMG35 + WINDOWS10 is really working?

What stpes do I have to taken in order to get it all working?

Thx, Serge

Hi Serge ...
I use MariaDB 5.5.68 version for 64-bit Windows. and HMG 3.4.4 32 bits. Latest version of HeidiSQL for 64 bits.
Operating system guess W7 Home Premium SP1 x64 as virtual machine in VirtualBox with 3gb. Ram, two core and LAN in bridge mode.
Operating system host (at the moment) is KDE Neon 5.19 64-bit. with 12 gb. ram, quadcore 3.9ghz.
And it works perfectly ...
I use that version of MariaDB because I don't need the features of the newer versions and because it is 100% compatible with MySQL.
In a commercial remote host with CentOS 7 and MariaDB the latest version a year and a half ago, a client with two programs that I made with HMG 3.4.4 accesses it from four branches of his shops without problems.
HeidiSQL is similar to Navicat but more comfortable to use as well as free.
I haven't tried HMG 3.5 yet due to lack of time.
MariaDB works perfectly in W10 (a friend has it like this)
On Youtube there are many videos about the installation.

You just need to put libmysql.dll in the folder of the program you are making and add a fourth parameter (port) to the Harbor function so that it looks like this:
oServer: = TMySQLServer (): New (cHostName, cUserName, cPassWord, nHostPort)
and assign the port number to that variable, in this case 3306 but you can use another one, without it (to me), I did not connect with the hosting.
In the MariaDB .msi include Heidi but is better not install this version and download the latest from official page.
Download MariaDB all version: https://mariadb.org/download/
Download HeidiSQL: https://www.heidisql.com/

Estimados
con mysql y mariadb 5.x funciona eso nadie los discute...

a ver mejor los desafio

Intenten compilar ejecutar y acceder a Mariadb 10(64 bits) y superiores compilando con esa libreria libmysql.dll y libmysql.a y diganme que funciona.

Yo no hablo de mysql, hablo de Mariadb 10 y superiores... que a mi modo de ver y despues trabajar mucho con esta base de datos me parece mucho pero mucho mejor que mysql de oracle.

Saludos

Hola Ismach...
Si lo tienes en un hosting, crea una DB como la de la foto y pasame los datos:
IP o dominio, puerto, usuario, password y nombre de la DB
que intento conectar y cargar un par de datos en ella desde un programa
que estoy desarrollando.

No no tengo, el unico que tengo esta en mysql 5.1.

Claudio,

Maybe I was not very clear... My database is hosted and they use MariaDB 10.4
This is fine and no problem to me when I use HMG344 (32b) and W10. HMG344 (64b) and HMG35 and won't work with libmysql.dll.

Serge

Hi Serge ... excuse me please.
I use 32-bit HMG 3.4.4 because even today there are those who use 32-bit W7, W8, W10,
it is to avoid compatibility problems with clients that have older computers.
HMG 3.5 I have not tried it yet because I read in the forum that some things did not work quite well,
but when I have a free weekend (something difficult because I have a lot of work) I download it,
and I will tell here if it worked well for me.

Thanks Claudio, it is not a matter of life and death..! I continue with HMG344 + W10 32b for the time being.

Serge